In [1]:
#!/usr/bin/python
#coding=utf-8
import numpy as np
import pandas as pd
import csv
import re
import os
import sys
import operator
import datetime
import time
import matplotlib.pyplot as plt
from datetime import *
from matplotlib import *
style.use("ggplot")
from csv import *
from openpyxl import *
from xlrd import *
In [2]:
#grep rows with suffix "_G"
filename1 = 'bigdata_correct.xlsx'
df = pd.read_excel(filename1, sheetname='Data')
df = df[df.IdentNo.str[-2:] == "_G"]
In [3]:
# Add two more columns to the data-frame
df = df.values
a,b = df.shape
z = np.zeros((a,2))
df = np.hstack((df,z))
a,b = df.shape
In [4]:
#list all different types of products
list1 = []
list_process_number = []
ttnr_list = []
for varia in range(a):
vari = str(df[varia][2]) + "_" + str(df[varia][3])
v1 = str(df[varia][2])
v2 = str(df[varia][3])
t = len(list1)
flag = 0
for i in range(t):
if list1[i] == vari:
flag = 1
break
if (flag == 0):
list1.append(vari)
list_process_number.append(v1)
ttnr_list.append(v2)
unique_sets = len(list1)
print (list1)
print (unique_sets)
['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038305588', '116_1038305588', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359'] 33
In [5]:
#assigning product number depending on TTNR to the data-set
for i in range(a):
concat= str(df[i][2]) + "_" + str(df[i][3])
for ii in range(unique_sets):
if (list1[ii] == concat):
df[i][4] = ii + 1
break
In [6]:
timers = 180
a,b = df.shape
flag = 0
count = 0
value_prev = "0"
date_prev = "0"
final_array = []
total_size = 0
for i in range(a):
total_size += 1
if flag == 0:
final_array.append([])
final_array[count].append(df[i][4])
final_array[count].append(df[i][1])
total_size = 1
flag = 1
elif df[i][4] != value_prev:
final_array[count].append(date_prev)
final_array[count].append(total_size - 1)
count += 1
final_array.append([])
final_array[count].append(df[i][4])
final_array[count].append(df[i][1])
total_size = 1
else:
t1 = pd.to_datetime(date_prev)
t2 = pd.to_datetime(df[i][1])
time = pd.Timedelta(t2 - t1).seconds + pd.Timedelta(t2 - t1).days*24*60*60
if (time > timers):
final_array[count].append(date_prev)
final_array[count].append(total_size - 1)
count = count + 1
final_array.append([])
final_array[count].append(df[i][4])
final_array[count].append(df[i][1])
total_size = 1
df[i][5] = count + 1
value_prev = df[i][4]
date_prev = df[i][1]
if (i == a-1):
final_array[count].append(date_prev)
final_array[count].append(total_size - 1)
print (final_array)
print (df)
np.savetxt("product_type_correct.csv", df, fmt="%s", delimiter=",")
np.savetxt("timelist_correct.csv", final_array, fmt="%s", delimiter=",")
'''
final_array
[product type number, starting time_stamp, ending time_stamp, number of entries in each batch/ Batch Quantity]
df
[product_name, time_stamp, process_number, TTNR, product type number ,batch/group number]
'''
[[1, Timestamp('2018-04-02 06:34:01'), Timestamp('2018-04-02 06:44:06'), 14], [1, Timestamp('2018-04-02 06:47:38'), Timestamp('2018-04-02 06:47:38'), 1], [1, Timestamp('2018-04-02 06:50:51'), Timestamp('2018-04-02 06:52:45'), 5], [1, Timestamp('2018-04-02 06:56:41'), Timestamp('2018-04-02 06:57:33'), 3], [1, Timestamp('2018-04-02 07:05:56'), Timestamp('2018-04-02 07:07:26'), 3], [1, Timestamp('2018-04-02 07:17:38'), Timestamp('2018-04-02 07:19:06'), 3], [1, Timestamp('2018-04-02 07:23:03'), Timestamp('2018-04-02 07:23:42'), 2], [1, Timestamp('2018-04-02 07:30:15'), Timestamp('2018-04-02 07:51:57'), 29], [1, Timestamp('2018-04-02 08:09:20'), Timestamp('2018-04-02 08:40:07'), 41], [1, Timestamp('2018-04-02 08:47:04'), Timestamp('2018-04-02 08:48:39'), 5], [1, Timestamp('2018-04-02 09:01:21'), Timestamp('2018-04-02 09:02:08'), 3], [2, Timestamp('2018-04-02 09:27:57'), Timestamp('2018-04-02 09:36:45'), 11], [2, Timestamp('2018-04-02 09:39:47'), Timestamp('2018-04-02 09:40:34'), 2], [2, Timestamp('2018-04-02 09:46:17'), Timestamp('2018-04-02 10:29:57'), 65], [2, Timestamp('2018-04-02 10:33:02'), Timestamp('2018-04-02 10:43:20'), 14], [2, Timestamp('2018-04-02 10:47:34'), Timestamp('2018-04-02 10:49:01'), 3], [2, Timestamp('2018-04-02 10:55:52'), Timestamp('2018-04-02 11:03:21'), 9], [2, Timestamp('2018-04-02 11:07:50'), Timestamp('2018-04-02 11:42:06'), 48], [2, Timestamp('2018-04-02 11:47:45'), Timestamp('2018-04-02 11:56:25'), 9], [3, Timestamp('2018-04-02 12:06:47'), Timestamp('2018-04-02 12:36:26'), 42], [3, Timestamp('2018-04-02 12:42:51'), Timestamp('2018-04-02 12:53:31'), 16], [3, Timestamp('2018-04-02 12:59:11'), Timestamp('2018-04-02 13:02:36'), 5], [3, Timestamp('2018-04-02 13:06:49'), Timestamp('2018-04-02 13:25:01'), 27], [3, Timestamp('2018-04-02 13:29:11'), Timestamp('2018-04-02 13:34:46'), 6], [3, Timestamp('2018-04-02 13:43:58'), Timestamp('2018-04-02 13:57:01'), 23], [3, Timestamp('2018-04-02 14:02:11'), Timestamp('2018-04-02 14:10:28'), 11], [3, Timestamp('2018-04-02 14:15:38'), Timestamp('2018-04-02 14:28:39'), 21], [3, Timestamp('2018-04-02 14:33:45'), Timestamp('2018-04-02 14:37:05'), 9], [4, Timestamp('2018-04-02 15:33:19'), Timestamp('2018-04-02 15:34:33'), 3], [4, Timestamp('2018-04-02 15:38:25'), Timestamp('2018-04-02 15:51:03'), 20], [4, Timestamp('2018-04-02 16:02:07'), Timestamp('2018-04-02 16:02:07'), 1], [4, Timestamp('2018-04-02 16:24:42'), Timestamp('2018-04-02 16:29:52'), 6], [4, Timestamp('2018-04-02 16:33:24'), Timestamp('2018-04-02 16:58:35'), 21], [4, Timestamp('2018-04-02 17:01:39'), Timestamp('2018-04-02 17:08:54'), 5], [4, Timestamp('2018-04-02 17:22:28'), Timestamp('2018-04-02 17:26:09'), 7], [4, Timestamp('2018-04-02 17:29:38'), Timestamp('2018-04-02 17:32:44'), 4], [4, Timestamp('2018-04-02 17:36:15'), Timestamp('2018-04-02 17:38:06'), 3], [4, Timestamp('2018-04-02 17:41:50'), Timestamp('2018-04-02 17:43:17'), 4], [4, Timestamp('2018-04-02 17:46:26'), Timestamp('2018-04-02 18:14:17'), 28], [4, Timestamp('2018-04-02 18:17:25'), Timestamp('2018-04-02 18:23:10'), 8], [4, Timestamp('2018-04-02 18:28:48'), Timestamp('2018-04-02 18:34:09'), 9], [5, Timestamp('2018-04-02 18:42:28'), Timestamp('2018-04-02 18:52:59'), 16], [5, Timestamp('2018-04-02 18:59:39'), Timestamp('2018-04-02 19:23:45'), 37], [5, Timestamp('2018-04-02 19:32:44'), Timestamp('2018-04-02 19:52:01'), 28], [5, Timestamp('2018-04-02 20:00:33'), Timestamp('2018-04-02 20:13:19'), 20], [5, Timestamp('2018-04-02 20:24:52'), Timestamp('2018-04-02 20:29:46'), 8], [5, Timestamp('2018-04-02 20:34:42'), Timestamp('2018-04-02 20:39:44'), 9], [6, Timestamp('2018-04-02 21:02:38'), Timestamp('2018-04-02 21:03:17'), 3], [6, Timestamp('2018-04-02 21:10:23'), Timestamp('2018-04-02 21:18:48'), 14], [6, Timestamp('2018-04-02 21:23:05'), Timestamp('2018-04-02 21:27:15'), 9], [6, Timestamp('2018-04-02 21:33:03'), Timestamp('2018-04-02 21:37:35'), 12], [6, Timestamp('2018-04-02 21:40:46'), Timestamp('2018-04-02 21:54:06'), 26], [6, Timestamp('2018-04-02 22:00:37'), Timestamp('2018-04-02 22:17:32'), 34], [6, Timestamp('2018-04-02 22:21:27'), Timestamp('2018-04-02 22:23:28'), 5], [6, Timestamp('2018-04-02 22:27:08'), Timestamp('2018-04-02 22:34:48'), 14], [6, Timestamp('2018-04-02 22:38:46'), Timestamp('2018-04-02 23:53:19'), 117], [6, Timestamp('2018-04-02 23:56:35'), Timestamp('2018-04-03 00:35:37'), 57], [6, Timestamp('2018-04-03 00:40:14'), Timestamp('2018-04-03 00:43:03'), 8], [6, Timestamp('2018-04-03 00:46:42'), Timestamp('2018-04-03 01:02:30'), 24], [7, Timestamp('2018-04-03 01:40:45'), Timestamp('2018-04-03 01:53:24'), 22], [7, Timestamp('2018-04-03 01:57:26'), Timestamp('2018-04-03 02:42:43'), 71], [7, Timestamp('2018-04-03 02:47:37'), Timestamp('2018-04-03 03:26:57'), 65], [7, Timestamp('2018-04-03 03:32:07'), Timestamp('2018-04-03 03:55:31'), 39], [7, Timestamp('2018-04-03 04:08:56'), Timestamp('2018-04-03 05:04:37'), 81], [7, Timestamp('2018-04-03 05:12:16'), Timestamp('2018-04-03 05:20:06'), 16], [7, Timestamp('2018-04-03 05:24:07'), Timestamp('2018-04-03 05:39:55'), 28], [8, Timestamp('2018-04-03 06:02:56'), Timestamp('2018-04-03 06:04:19'), 3], [8, Timestamp('2018-04-03 10:59:54'), Timestamp('2018-04-03 11:04:54'), 6], [8, Timestamp('2018-04-03 11:09:01'), Timestamp('2018-04-03 11:30:18'), 26], [8, Timestamp('2018-04-03 11:35:10'), Timestamp('2018-04-03 11:47:22'), 11], [8, Timestamp('2018-04-03 11:53:49'), Timestamp('2018-04-03 11:54:56'), 2], [8, Timestamp('2018-04-03 12:09:38'), Timestamp('2018-04-03 12:09:38'), 1], [8, Timestamp('2018-04-03 12:13:25'), Timestamp('2018-04-03 12:21:15'), 7], [8, Timestamp('2018-04-03 12:28:45'), Timestamp('2018-04-03 12:32:17'), 5], [8, Timestamp('2018-04-03 12:35:26'), Timestamp('2018-04-03 12:42:12'), 8], [8, Timestamp('2018-04-03 12:48:45'), Timestamp('2018-04-03 12:48:45'), 1], [8, Timestamp('2018-04-03 12:55:27'), Timestamp('2018-04-03 12:58:04'), 4], [8, Timestamp('2018-04-03 13:32:46'), Timestamp('2018-04-03 13:32:46'), 1], [8, Timestamp('2018-04-03 13:42:33'), Timestamp('2018-04-03 13:43:24'), 2], [8, Timestamp('2018-04-03 13:50:09'), Timestamp('2018-04-03 13:56:56'), 9], [8, Timestamp('2018-04-03 14:17:02'), Timestamp('2018-04-03 14:18:41'), 3], [8, Timestamp('2018-04-03 14:24:17'), Timestamp('2018-04-03 14:35:41'), 15], [8, Timestamp('2018-04-03 14:38:59'), Timestamp('2018-04-03 15:04:49'), 31], [8, Timestamp('2018-04-03 15:09:54'), Timestamp('2018-04-03 15:21:13'), 15], [1, Timestamp('2018-04-03 15:29:04'), Timestamp('2018-04-03 15:39:19'), 23], [1, Timestamp('2018-04-03 15:43:47'), Timestamp('2018-04-03 15:49:16'), 11], [1, Timestamp('2018-04-03 15:56:50'), Timestamp('2018-04-03 15:58:36'), 6], [1, Timestamp('2018-04-03 16:09:51'), Timestamp('2018-04-03 16:19:23'), 11], [1, Timestamp('2018-04-03 16:25:32'), Timestamp('2018-04-03 16:33:28'), 11], [1, Timestamp('2018-04-03 16:44:17'), Timestamp('2018-04-03 16:53:16'), 17], [1, Timestamp('2018-04-03 16:57:36'), Timestamp('2018-04-03 16:57:36'), 1], [1, Timestamp('2018-04-03 17:02:53'), Timestamp('2018-04-03 17:16:35'), 22], [1, Timestamp('2018-04-03 17:22:14'), Timestamp('2018-04-03 17:28:55'), 15], [1, Timestamp('2018-04-03 17:35:13'), Timestamp('2018-04-03 17:43:40'), 13], [1, Timestamp('2018-04-03 17:46:55'), Timestamp('2018-04-03 18:02:00'), 20], [4, Timestamp('2018-04-03 18:35:52'), Timestamp('2018-04-03 18:37:33'), 4], [4, Timestamp('2018-04-03 18:47:37'), Timestamp('2018-04-03 19:20:55'), 39], [4, Timestamp('2018-04-03 19:25:05'), Timestamp('2018-04-03 19:29:07'), 5], [4, Timestamp('2018-04-03 19:35:21'), Timestamp('2018-04-03 20:06:23'), 46], [4, Timestamp('2018-04-03 20:10:50'), Timestamp('2018-04-03 20:31:06'), 26], [5, Timestamp('2018-04-03 20:41:23'), Timestamp('2018-04-03 21:13:06'), 42], [5, Timestamp('2018-04-03 21:16:46'), Timestamp('2018-04-03 21:28:35'), 18], [5, Timestamp('2018-04-03 21:32:01'), Timestamp('2018-04-03 21:38:58'), 12], [5, Timestamp('2018-04-03 21:43:13'), Timestamp('2018-04-03 21:55:19'), 14], [5, Timestamp('2018-04-03 21:59:10'), Timestamp('2018-04-03 22:06:39'), 12], [5, Timestamp('2018-04-03 22:10:41'), Timestamp('2018-04-03 22:26:51'), 23], [9, Timestamp('2018-04-03 22:36:52'), Timestamp('2018-04-03 23:15:54'), 55], [9, Timestamp('2018-04-03 23:22:44'), Timestamp('2018-04-03 23:45:41'), 36], [9, Timestamp('2018-04-03 23:49:01'), Timestamp('2018-04-04 00:06:12'), 27], [9, Timestamp('2018-04-04 00:09:30'), Timestamp('2018-04-04 00:11:30'), 5], [10, Timestamp('2018-04-04 00:36:31'), Timestamp('2018-04-04 00:39:47'), 6], [10, Timestamp('2018-04-04 00:44:06'), Timestamp('2018-04-04 00:56:06'), 14], [10, Timestamp('2018-04-04 01:00:58'), Timestamp('2018-04-04 01:05:43'), 6], [10, Timestamp('2018-04-04 01:35:55'), Timestamp('2018-04-04 02:26:01'), 54], [11, Timestamp('2018-04-04 02:35:36'), Timestamp('2018-04-04 03:07:11'), 41], [11, Timestamp('2018-04-04 03:12:44'), Timestamp('2018-04-04 03:19:30'), 11], [11, Timestamp('2018-04-04 03:23:01'), Timestamp('2018-04-04 03:39:29'), 26], [11, Timestamp('2018-04-04 03:44:17'), Timestamp('2018-04-04 04:09:05'), 38], [11, Timestamp('2018-04-04 04:14:23'), Timestamp('2018-04-04 04:16:24'), 7], [12, Timestamp('2018-04-04 04:38:27'), Timestamp('2018-04-04 04:46:02'), 7], [12, Timestamp('2018-04-04 04:52:50'), Timestamp('2018-04-04 04:56:58'), 5], [12, Timestamp('2018-04-04 05:00:33'), Timestamp('2018-04-04 05:08:06'), 7], [12, Timestamp('2018-04-04 05:14:51'), Timestamp('2018-04-04 05:28:16'), 10], [12, Timestamp('2018-04-04 05:31:17'), Timestamp('2018-04-04 05:36:53'), 3], [12, Timestamp('2018-04-04 05:43:26'), Timestamp('2018-04-04 05:46:17'), 2], [12, Timestamp('2018-04-04 06:01:20'), Timestamp('2018-04-04 06:02:24'), 3], [12, Timestamp('2018-04-04 06:58:48'), Timestamp('2018-04-04 07:02:26'), 6], [12, Timestamp('2018-04-04 07:12:31'), Timestamp('2018-04-04 07:16:38'), 7], [12, Timestamp('2018-04-04 07:23:22'), Timestamp('2018-04-04 07:33:39'), 8], [12, Timestamp('2018-04-04 08:29:09'), Timestamp('2018-04-04 08:29:09'), 1], [12, Timestamp('2018-04-04 08:55:36'), Timestamp('2018-04-04 09:13:08'), 20], [6, Timestamp('2018-04-04 09:38:29'), Timestamp('2018-04-04 09:38:30'), 2], [6, Timestamp('2018-04-04 09:47:57'), Timestamp('2018-04-04 11:21:17'), 156], [7, Timestamp('2018-04-04 12:06:36'), Timestamp('2018-04-04 12:17:14'), 19], [7, Timestamp('2018-04-04 12:25:30'), Timestamp('2018-04-04 12:29:34'), 12], [7, Timestamp('2018-04-04 12:33:04'), Timestamp('2018-04-04 12:34:58'), 3], [7, Timestamp('2018-04-04 13:23:34'), Timestamp('2018-04-04 13:26:24'), 4], [7, Timestamp('2018-04-04 13:29:48'), Timestamp('2018-04-04 13:29:48'), 1], [7, Timestamp('2018-04-04 13:35:19'), Timestamp('2018-04-04 14:24:22'), 80], [7, Timestamp('2018-04-04 14:28:58'), Timestamp('2018-04-04 14:47:10'), 36], [4, Timestamp('2018-04-04 14:59:41'), Timestamp('2018-04-04 15:16:31'), 21], [4, Timestamp('2018-04-04 15:41:34'), Timestamp('2018-04-04 16:00:31'), 23], [4, Timestamp('2018-04-04 16:04:15'), Timestamp('2018-04-04 16:12:38'), 12], [4, Timestamp('2018-04-04 16:15:40'), Timestamp('2018-04-04 16:15:40'), 1], [4, Timestamp('2018-04-04 16:20:10'), Timestamp('2018-04-04 16:24:45'), 5], [4, Timestamp('2018-04-04 16:29:03'), Timestamp('2018-04-04 16:32:02'), 5], [4, Timestamp('2018-04-04 16:35:11'), Timestamp('2018-04-04 16:53:30'), 23], [4, Timestamp('2018-04-04 16:57:02'), Timestamp('2018-04-04 17:02:20'), 8], [4, Timestamp('2018-04-04 17:08:37'), Timestamp('2018-04-04 17:08:37'), 1], [4, Timestamp('2018-04-04 17:12:52'), Timestamp('2018-04-04 17:14:44'), 4], [4, Timestamp('2018-04-04 17:22:03'), Timestamp('2018-04-04 17:22:03'), 1], [4, Timestamp('2018-04-04 17:36:45'), Timestamp('2018-04-04 17:47:23'), 17], [5, Timestamp('2018-04-04 17:59:33'), Timestamp('2018-04-04 17:59:33'), 1], [5, Timestamp('2018-04-04 18:07:17'), Timestamp('2018-04-04 18:22:01'), 29], [5, Timestamp('2018-04-04 18:27:59'), Timestamp('2018-04-04 19:05:39'), 46], [5, Timestamp('2018-04-04 19:13:12'), Timestamp('2018-04-04 19:19:12'), 10], [5, Timestamp('2018-04-04 19:30:39'), Timestamp('2018-04-04 19:38:10'), 17], [5, Timestamp('2018-04-04 19:42:15'), Timestamp('2018-04-04 19:50:58'), 18], [9, Timestamp('2018-04-04 19:57:17'), Timestamp('2018-04-04 20:09:36'), 15], [9, Timestamp('2018-04-04 20:13:07'), Timestamp('2018-04-04 20:18:54'), 11], [9, Timestamp('2018-04-04 20:21:56'), Timestamp('2018-04-04 20:25:20'), 8], [9, Timestamp('2018-04-04 20:34:24'), Timestamp('2018-04-04 20:49:54'), 20], [9, Timestamp('2018-04-04 20:55:20'), Timestamp('2018-04-04 21:14:57'), 25], [11, Timestamp('2018-04-04 21:23:50'), Timestamp('2018-04-04 21:23:50'), 1], [11, Timestamp('2018-04-04 21:28:17'), Timestamp('2018-04-04 21:42:16'), 22], [11, Timestamp('2018-04-04 21:46:19'), Timestamp('2018-04-04 21:54:45'), 17], [11, Timestamp('2018-04-04 21:58:05'), Timestamp('2018-04-04 22:11:20'), 21], [11, Timestamp('2018-04-04 22:15:50'), Timestamp('2018-04-04 22:23:23'), 17], [8, Timestamp('2018-04-04 23:04:35'), Timestamp('2018-04-04 23:15:53'), 15], [8, Timestamp('2018-04-04 23:21:14'), Timestamp('2018-04-04 23:21:59'), 4], [8, Timestamp('2018-04-04 23:25:02'), Timestamp('2018-04-04 23:33:23'), 10], [8, Timestamp('2018-04-04 23:38:08'), Timestamp('2018-04-04 23:45:14'), 9], [8, Timestamp('2018-04-04 23:52:42'), Timestamp('2018-04-04 23:58:29'), 8], [8, Timestamp('2018-04-05 00:02:00'), Timestamp('2018-04-05 00:48:48'), 54], [8, Timestamp('2018-04-05 00:52:15'), Timestamp('2018-04-05 01:03:21'), 17], [1, Timestamp('2018-04-05 01:08:55'), Timestamp('2018-04-05 01:22:23'), 16], [1, Timestamp('2018-04-05 01:28:48'), Timestamp('2018-04-05 01:45:08'), 25], [1, Timestamp('2018-04-05 01:48:52'), Timestamp('2018-04-05 01:50:29'), 4], [1, Timestamp('2018-04-05 01:54:53'), Timestamp('2018-04-05 02:14:10'), 36], [1, Timestamp('2018-04-05 02:18:16'), Timestamp('2018-04-05 02:23:03'), 12], [1, Timestamp('2018-04-05 02:29:42'), Timestamp('2018-04-05 02:39:10'), 19], [2, Timestamp('2018-04-05 02:58:41'), Timestamp('2018-04-05 03:03:04'), 8], [2, Timestamp('2018-04-05 03:06:35'), Timestamp('2018-04-05 03:18:26'), 13], [2, Timestamp('2018-04-05 03:22:35'), Timestamp('2018-04-05 04:00:31'), 48], [2, Timestamp('2018-04-05 04:04:40'), Timestamp('2018-04-05 04:12:16'), 11], [10, Timestamp('2018-04-05 04:28:42'), Timestamp('2018-04-05 04:49:11'), 22], [10, Timestamp('2018-04-05 04:52:13'), Timestamp('2018-04-05 04:52:13'), 1], [10, Timestamp('2018-04-05 04:55:27'), Timestamp('2018-04-05 04:55:27'), 1], [10, Timestamp('2018-04-05 04:58:51'), Timestamp('2018-04-05 04:59:27'), 2], [3, Timestamp('2018-04-05 05:08:01'), Timestamp('2018-04-05 05:57:08'), 67], [3, Timestamp('2018-04-05 06:01:02'), Timestamp('2018-04-05 06:10:23'), 13], [13, Timestamp('2018-04-05 06:23:32'), Timestamp('2018-04-05 07:26:16'), 81], [14, Timestamp('2018-04-05 07:32:30'), Timestamp('2018-04-05 08:26:13'), 63], [14, Timestamp('2018-04-05 20:51:18'), Timestamp('2018-04-05 20:51:31'), 2], [14, Timestamp('2018-04-05 21:09:13'), Timestamp('2018-04-05 21:21:41'), 16], [8, Timestamp('2018-04-05 21:57:05'), Timestamp('2018-04-05 22:05:53'), 10], [8, Timestamp('2018-04-05 22:09:39'), Timestamp('2018-04-05 23:46:28'), 110], [15, Timestamp('2018-04-06 00:02:58'), Timestamp('2018-04-06 00:03:34'), 2], [15, Timestamp('2018-04-06 00:06:38'), Timestamp('2018-04-06 00:32:29'), 35], [15, Timestamp('2018-04-06 00:45:25'), Timestamp('2018-04-06 00:48:50'), 3], [15, Timestamp('2018-04-06 00:52:21'), Timestamp('2018-04-06 00:52:21'), 1], [15, Timestamp('2018-04-06 00:57:35'), Timestamp('2018-04-06 00:57:35'), 1], [16, Timestamp('2018-04-06 01:11:29'), Timestamp('2018-04-06 02:05:33'), 60], [16, Timestamp('2018-04-06 02:09:00'), Timestamp('2018-04-06 02:12:17'), 5], [16, Timestamp('2018-04-06 02:15:31'), Timestamp('2018-04-06 02:27:22'), 15], [1, Timestamp('2018-04-06 02:40:39'), Timestamp('2018-04-06 03:06:40'), 34], [1, Timestamp('2018-04-06 03:10:46'), Timestamp('2018-04-06 03:13:10'), 9], [1, Timestamp('2018-04-06 03:17:02'), Timestamp('2018-04-06 03:22:33'), 9], [1, Timestamp('2018-04-06 03:27:28'), Timestamp('2018-04-06 03:38:34'), 16], [1, Timestamp('2018-04-06 03:42:25'), Timestamp('2018-04-06 04:14:41'), 44], [1, Timestamp('2018-04-06 04:19:02'), Timestamp('2018-04-06 04:19:02'), 1], [1, Timestamp('2018-04-06 04:22:14'), Timestamp('2018-04-06 04:31:45'), 7], [17, Timestamp('2018-04-06 04:35:04'), Timestamp('2018-04-06 04:48:31'), 19], [17, Timestamp('2018-04-06 04:53:19'), Timestamp('2018-04-06 04:53:40'), 2], [17, Timestamp('2018-04-06 05:01:17'), Timestamp('2018-04-06 05:08:20'), 11], [17, Timestamp('2018-04-06 05:13:36'), Timestamp('2018-04-06 05:14:56'), 4], [17, Timestamp('2018-04-06 05:19:14'), Timestamp('2018-04-06 05:22:53'), 5], [18, Timestamp('2018-04-06 05:26:31'), Timestamp('2018-04-06 05:33:09'), 14], [18, Timestamp('2018-04-06 05:38:04'), Timestamp('2018-04-06 06:05:55'), 45], [18, Timestamp('2018-04-06 06:10:28'), Timestamp('2018-04-06 06:27:38'), 21], [8, Timestamp('2018-04-06 06:41:12'), Timestamp('2018-04-06 07:11:42'), 36], [8, Timestamp('2018-04-06 07:16:00'), Timestamp('2018-04-06 07:25:18'), 12], [8, Timestamp('2018-04-06 07:32:05'), Timestamp('2018-04-06 07:36:22'), 6], [8, Timestamp('2018-04-06 07:40:15'), Timestamp('2018-04-06 08:05:10'), 29], [8, Timestamp('2018-04-06 08:09:10'), Timestamp('2018-04-06 08:12:36'), 5], [8, Timestamp('2018-04-06 08:19:53'), Timestamp('2018-04-06 08:46:24'), 32], [1, Timestamp('2018-04-06 09:07:22'), Timestamp('2018-04-06 09:23:54'), 23], [1, Timestamp('2018-04-06 09:29:09'), Timestamp('2018-04-06 09:35:21'), 10], [1, Timestamp('2018-04-06 09:38:22'), Timestamp('2018-04-06 09:56:26'), 28], [1, Timestamp('2018-04-06 10:03:59'), Timestamp('2018-04-06 10:16:01'), 20], [19, Timestamp('2018-04-06 14:13:40'), Timestamp('2018-04-06 14:15:50'), 2], [19, Timestamp('2018-04-06 14:22:36'), Timestamp('2018-04-06 14:26:32'), 13], [20, Timestamp('2018-04-06 16:26:31'), Timestamp('2018-04-06 16:27:27'), 2], [20, Timestamp('2018-04-06 16:32:16'), Timestamp('2018-04-06 16:36:11'), 3], [21, Timestamp('2018-04-06 17:22:06'), Timestamp('2018-04-06 17:34:18'), 14], [21, Timestamp('2018-04-06 17:38:28'), Timestamp('2018-04-06 17:38:28'), 1], [4, Timestamp('2018-04-06 17:51:02'), Timestamp('2018-04-06 18:01:06'), 15], [4, Timestamp('2018-04-06 18:05:22'), Timestamp('2018-04-06 18:05:22'), 1], [4, Timestamp('2018-04-06 18:10:29'), Timestamp('2018-04-06 18:10:29'), 1], [4, Timestamp('2018-04-06 18:14:04'), Timestamp('2018-04-06 18:42:21'), 39], [4, Timestamp('2018-04-06 18:46:06'), Timestamp('2018-04-06 18:50:08'), 7], [4, Timestamp('2018-04-06 19:01:07'), Timestamp('2018-04-06 19:43:17'), 63], [5, Timestamp('2018-04-06 20:04:25'), Timestamp('2018-04-06 20:09:40'), 14], [5, Timestamp('2018-04-06 20:15:34'), Timestamp('2018-04-06 21:43:58'), 112], [9, Timestamp('2018-04-06 22:04:56'), Timestamp('2018-04-06 22:27:01'), 23], [9, Timestamp('2018-04-06 22:33:51'), Timestamp('2018-04-06 22:36:12'), 3], [9, Timestamp('2018-04-06 22:39:25'), Timestamp('2018-04-06 22:42:32'), 6], [9, Timestamp('2018-04-06 22:46:23'), Timestamp('2018-04-06 22:50:12'), 5], [9, Timestamp('2018-04-06 22:56:25'), Timestamp('2018-04-06 23:00:13'), 4], [9, Timestamp('2018-04-06 23:05:12'), Timestamp('2018-04-06 23:12:07'), 11], [9, Timestamp('2018-04-06 23:16:05'), Timestamp('2018-04-06 23:31:25'), 28], [2, Timestamp('2018-04-06 23:36:25'), Timestamp('2018-04-06 23:38:33'), 3], [2, Timestamp('2018-04-06 23:42:14'), Timestamp('2018-04-06 23:45:09'), 2], [2, Timestamp('2018-04-06 23:48:19'), Timestamp('2018-04-07 00:07:52'), 25], [2, Timestamp('2018-04-07 00:13:20'), Timestamp('2018-04-07 00:21:58'), 12], [2, Timestamp('2018-04-07 00:26:36'), Timestamp('2018-04-07 00:35:07'), 11], [2, Timestamp('2018-04-07 00:40:54'), Timestamp('2018-04-07 00:55:52'), 20], [2, Timestamp('2018-04-07 00:59:05'), Timestamp('2018-04-07 01:01:05'), 5], [11, Timestamp('2018-04-07 01:10:35'), Timestamp('2018-04-07 01:10:35'), 1], [11, Timestamp('2018-04-07 01:14:14'), Timestamp('2018-04-07 01:42:01'), 33], [11, Timestamp('2018-04-07 01:45:50'), Timestamp('2018-04-07 02:12:09'), 38], [11, Timestamp('2018-04-07 02:15:16'), Timestamp('2018-04-07 02:18:23'), 8], [3, Timestamp('2018-04-07 02:23:31'), Timestamp('2018-04-07 02:31:20'), 8], [3, Timestamp('2018-04-07 02:35:31'), Timestamp('2018-04-07 02:44:25'), 18], [3, Timestamp('2018-04-07 02:48:41'), Timestamp('2018-04-07 02:54:41'), 12], [3, Timestamp('2018-04-07 02:58:01'), Timestamp('2018-04-07 03:20:34'), 25], [3, Timestamp('2018-04-07 03:23:39'), Timestamp('2018-04-07 03:23:39'), 1], [3, Timestamp('2018-04-07 03:30:53'), Timestamp('2018-04-07 03:35:57'), 8], [3, Timestamp('2018-04-07 03:39:26'), Timestamp('2018-04-07 03:40:51'), 6], [6, Timestamp('2018-04-07 04:14:04'), Timestamp('2018-04-07 04:31:50'), 38], [6, Timestamp('2018-04-07 04:36:09'), Timestamp('2018-04-07 05:18:12'), 83], [6, Timestamp('2018-04-07 05:22:08'), Timestamp('2018-04-07 05:30:37'), 17], [6, Timestamp('2018-04-07 05:37:56'), Timestamp('2018-04-07 05:54:22'), 36], [7, Timestamp('2018-04-07 06:11:28'), Timestamp('2018-04-07 06:31:25'), 35], [7, Timestamp('2018-04-07 06:38:20'), Timestamp('2018-04-07 08:07:23'), 139], [16, Timestamp('2018-04-07 08:55:27'), Timestamp('2018-04-07 09:44:04'), 56], [16, Timestamp('2018-04-07 09:48:25'), Timestamp('2018-04-07 09:49:15'), 2], [8, Timestamp('2018-04-07 09:53:13'), Timestamp('2018-04-07 10:06:27'), 14], [8, Timestamp('2018-04-07 10:10:08'), Timestamp('2018-04-07 10:14:17'), 6], [8, Timestamp('2018-04-07 10:17:42'), Timestamp('2018-04-07 11:26:48'), 74], [8, Timestamp('2018-04-07 11:44:11'), Timestamp('2018-04-07 12:07:56'), 26], [18, Timestamp('2018-04-07 12:10:13'), Timestamp('2018-04-07 12:51:55'), 57], [1, Timestamp('2018-04-07 13:12:19'), Timestamp('2018-04-07 13:22:18'), 12], [1, Timestamp('2018-04-07 13:25:28'), Timestamp('2018-04-07 13:40:25'), 26], [1, Timestamp('2018-04-07 13:44:07'), Timestamp('2018-04-07 14:07:42'), 36], [1, Timestamp('2018-04-07 14:13:12'), Timestamp('2018-04-07 14:19:22'), 11], [1, Timestamp('2018-04-07 14:24:39'), Timestamp('2018-04-07 15:05:49'), 63], [1, Timestamp('2018-04-07 15:10:28'), Timestamp('2018-04-07 15:15:09'), 11], [4, Timestamp('2018-04-07 15:34:01'), Timestamp('2018-04-07 16:30:30'), 72], [4, Timestamp('2018-04-07 16:36:46'), Timestamp('2018-04-07 17:16:28'), 48], [9, Timestamp('2018-04-07 17:20:05'), Timestamp('2018-04-07 17:20:05'), 1], [9, Timestamp('2018-04-07 17:25:09'), Timestamp('2018-04-07 17:28:17'), 6], [9, Timestamp('2018-04-07 17:34:58'), Timestamp('2018-04-07 17:40:50'), 10], [9, Timestamp('2018-04-07 17:50:51'), Timestamp('2018-04-07 17:58:48'), 12], [9, Timestamp('2018-04-07 18:02:03'), Timestamp('2018-04-07 18:26:46'), 40], [9, Timestamp('2018-04-07 18:34:03'), Timestamp('2018-04-07 18:39:22'), 8], [9, Timestamp('2018-04-07 18:42:35'), Timestamp('2018-04-07 18:44:30'), 3], [5, Timestamp('2018-04-07 18:56:30'), Timestamp('2018-04-07 19:15:14'), 34], [5, Timestamp('2018-04-07 19:19:14'), Timestamp('2018-04-07 19:26:37'), 13], [5, Timestamp('2018-04-07 19:32:56'), Timestamp('2018-04-07 19:41:37'), 12], [5, Timestamp('2018-04-07 19:48:16'), Timestamp('2018-04-07 19:49:51'), 3], [5, Timestamp('2018-04-07 19:53:06'), Timestamp('2018-04-07 20:38:17'), 58], [11, Timestamp('2018-04-07 20:42:47'), Timestamp('2018-04-07 21:03:11'), 27], [11, Timestamp('2018-04-07 21:06:30'), Timestamp('2018-04-07 21:35:46'), 42], [11, Timestamp('2018-04-07 21:39:36'), Timestamp('2018-04-07 21:46:13'), 12], [2, Timestamp('2018-04-07 23:33:09'), Timestamp('2018-04-07 23:38:58'), 8], [2, Timestamp('2018-04-07 23:42:13'), Timestamp('2018-04-07 23:42:13'), 1], [2, Timestamp('2018-04-07 23:46:16'), Timestamp('2018-04-08 00:27:03'), 53], [2, Timestamp('2018-04-08 00:32:19'), Timestamp('2018-04-08 00:46:20'), 18], [4, Timestamp('2018-04-08 00:52:52'), Timestamp('2018-04-08 01:32:55'), 51], [4, Timestamp('2018-04-08 01:36:24'), Timestamp('2018-04-08 02:14:11'), 50], [4, Timestamp('2018-04-08 02:19:55'), Timestamp('2018-04-08 02:23:23'), 6], [3, Timestamp('2018-04-08 02:30:31'), Timestamp('2018-04-08 02:31:18'), 2], [3, Timestamp('2018-04-08 02:37:24'), Timestamp('2018-04-08 02:42:54'), 15], [3, Timestamp('2018-04-08 02:46:47'), Timestamp('2018-04-08 03:10:35'), 26], [3, Timestamp('2018-04-08 03:14:38'), Timestamp('2018-04-08 03:22:49'), 12], [3, Timestamp('2018-04-08 03:31:11'), Timestamp('2018-04-08 03:35:50'), 4], [3, Timestamp('2018-04-08 03:45:09'), Timestamp('2018-04-08 03:47:54'), 3], [3, Timestamp('2018-04-08 03:51:07'), Timestamp('2018-04-08 04:04:45'), 18], [5, Timestamp('2018-04-08 04:11:46'), Timestamp('2018-04-08 05:37:11'), 104], [5, Timestamp('2018-04-08 05:40:20'), Timestamp('2018-04-08 05:41:25'), 3], [4, Timestamp('2018-04-08 05:46:03'), Timestamp('2018-04-08 06:16:39'), 38], [4, Timestamp('2018-04-08 06:19:51'), Timestamp('2018-04-08 06:24:59'), 8], [4, Timestamp('2018-04-08 06:32:24'), Timestamp('2018-04-08 06:44:58'), 14], [4, Timestamp('2018-04-08 06:50:35'), Timestamp('2018-04-08 06:53:42'), 7], [4, Timestamp('2018-04-08 06:59:36'), Timestamp('2018-04-08 07:44:48'), 58], [4, Timestamp('2018-04-08 07:49:23'), Timestamp('2018-04-08 07:58:44'), 9], [4, Timestamp('2018-04-08 08:03:08'), Timestamp('2018-04-08 08:16:56'), 16], [5, Timestamp('2018-04-08 08:19:18'), Timestamp('2018-04-08 08:31:20'), 22], [5, Timestamp('2018-04-08 08:37:31'), Timestamp('2018-04-08 08:38:59'), 7], [5, Timestamp('2018-04-08 08:44:59'), Timestamp('2018-04-08 08:51:59'), 19], [5, Timestamp('2018-04-08 08:58:12'), Timestamp('2018-04-08 09:16:48'), 23], [5, Timestamp('2018-04-08 09:22:02'), Timestamp('2018-04-08 09:55:37'), 40], [5, Timestamp('2018-04-08 10:00:53'), Timestamp('2018-04-08 10:12:45'), 18], [5, Timestamp('2018-04-08 10:17:25'), Timestamp('2018-04-08 10:18:56'), 3], [5, Timestamp('2018-04-08 10:22:33'), Timestamp('2018-04-08 10:26:14'), 7], [5, Timestamp('2018-04-08 10:29:34'), Timestamp('2018-04-08 10:34:11'), 10], [4, Timestamp('2018-04-08 10:40:53'), Timestamp('2018-04-08 10:42:20'), 3], [4, Timestamp('2018-04-08 10:46:27'), Timestamp('2018-04-08 11:28:21'), 51], [4, Timestamp('2018-04-08 11:33:28'), Timestamp('2018-04-08 11:46:11'), 22], [4, Timestamp('2018-04-08 11:52:27'), Timestamp('2018-04-08 12:18:13'), 22], [5, Timestamp('2018-04-08 12:33:15'), Timestamp('2018-04-08 12:41:27'), 12], [5, Timestamp('2018-04-08 12:45:12'), Timestamp('2018-04-08 13:07:34'), 21], [5, Timestamp('2018-04-08 13:45:34'), Timestamp('2018-04-08 13:59:42'), 19], [4, Timestamp('2018-04-08 14:43:15'), Timestamp('2018-04-08 14:43:15'), 1], [4, Timestamp('2018-04-08 14:47:44'), Timestamp('2018-04-08 15:08:20'), 27], [4, Timestamp('2018-04-08 15:11:32'), Timestamp('2018-04-08 15:18:31'), 11], [4, Timestamp('2018-04-08 15:21:36'), Timestamp('2018-04-08 15:45:33'), 37], [4, Timestamp('2018-04-08 15:51:05'), Timestamp('2018-04-08 16:09:05'), 26], [9, Timestamp('2018-04-08 16:11:24'), Timestamp('2018-04-08 16:28:15'), 23], [9, Timestamp('2018-04-08 16:32:11'), Timestamp('2018-04-08 16:48:56'), 30], [9, Timestamp('2018-04-08 16:58:29'), Timestamp('2018-04-08 17:32:38'), 47], [5, Timestamp('2018-04-08 17:41:17'), Timestamp('2018-04-08 18:58:17'), 88], [5, Timestamp('2018-04-08 19:02:29'), Timestamp('2018-04-08 19:14:43'), 20], [5, Timestamp('2018-04-08 19:21:56'), Timestamp('2018-04-08 19:47:28'), 40], [5, Timestamp('2018-04-08 19:52:32'), Timestamp('2018-04-08 19:52:32'), 1], [11, Timestamp('2018-04-08 20:04:36'), Timestamp('2018-04-08 20:28:31'), 31], [11, Timestamp('2018-04-08 20:32:33'), Timestamp('2018-04-08 21:18:11'), 69], [4, Timestamp('2018-04-08 21:28:54'), Timestamp('2018-04-08 21:34:22'), 10], [4, Timestamp('2018-04-08 21:38:26'), Timestamp('2018-04-08 21:58:31'), 30], [4, Timestamp('2018-04-09 05:59:55'), Timestamp('2018-04-09 06:07:57'), 8], [4, Timestamp('2018-04-09 06:11:49'), Timestamp('2018-04-09 06:36:09'), 37], [4, Timestamp('2018-04-09 06:41:01'), Timestamp('2018-04-09 06:44:23'), 5], [4, Timestamp('2018-04-09 06:48:57'), Timestamp('2018-04-09 07:12:40'), 35], [5, Timestamp('2018-04-09 07:23:34'), Timestamp('2018-04-09 07:23:34'), 1], [5, Timestamp('2018-04-09 07:30:47'), Timestamp('2018-04-09 07:35:34'), 11], [5, Timestamp('2018-04-09 07:39:04'), Timestamp('2018-04-09 07:46:37'), 13], [5, Timestamp('2018-04-09 07:49:41'), Timestamp('2018-04-09 08:46:21'), 76], [5, Timestamp('2018-04-09 08:50:01'), Timestamp('2018-04-09 09:06:56'), 24], [16, Timestamp('2018-04-09 09:46:21'), Timestamp('2018-04-09 10:30:57'), 51], [16, Timestamp('2018-04-09 10:34:53'), Timestamp('2018-04-09 11:22:24'), 48], [16, Timestamp('2018-04-09 11:25:51'), Timestamp('2018-04-09 11:45:19'), 18], [18, Timestamp('2018-04-09 11:54:53'), Timestamp('2018-04-09 12:34:33'), 55], [18, Timestamp('2018-04-09 12:39:23'), Timestamp('2018-04-09 12:42:03'), 5], [18, Timestamp('2018-04-09 12:47:43'), Timestamp('2018-04-09 12:50:21'), 3], [18, Timestamp('2018-04-09 13:19:28'), Timestamp('2018-04-09 13:19:28'), 1], [18, Timestamp('2018-04-09 13:23:50'), Timestamp('2018-04-09 13:23:50'), 1], [18, Timestamp('2018-04-09 13:30:31'), Timestamp('2018-04-09 13:38:57'), 11], [18, Timestamp('2018-04-09 13:42:37'), Timestamp('2018-04-09 14:10:51'), 40], [8, Timestamp('2018-04-09 14:23:16'), Timestamp('2018-04-09 16:08:53'), 120], [1, Timestamp('2018-04-09 16:11:25'), Timestamp('2018-04-09 16:51:21'), 59], [1, Timestamp('2018-04-09 16:57:22'), Timestamp('2018-04-09 17:02:55'), 9], [1, Timestamp('2018-04-09 17:06:01'), Timestamp('2018-04-09 17:27:48'), 29], [1, Timestamp('2018-04-09 17:33:13'), Timestamp('2018-04-09 17:39:46'), 11], [1, Timestamp('2018-04-09 17:43:40'), Timestamp('2018-04-09 17:50:06'), 11], [19, Timestamp('2018-04-09 18:36:56'), Timestamp('2018-04-09 19:13:34'), 64], [19, Timestamp('2018-04-09 19:22:38'), Timestamp('2018-04-09 19:54:22'), 48], [19, Timestamp('2018-04-09 19:58:00'), Timestamp('2018-04-09 20:35:51'), 59], [19, Timestamp('2018-04-09 20:39:48'), Timestamp('2018-04-09 20:48:20'), 11], [19, Timestamp('2018-04-09 20:55:44'), Timestamp('2018-04-09 21:33:29'), 56], [21, Timestamp('2018-04-09 21:46:33'), Timestamp('2018-04-09 21:52:47'), 8], [21, Timestamp('2018-04-09 22:05:07'), Timestamp('2018-04-09 22:42:54'), 49], [21, Timestamp('2018-04-09 22:45:56'), Timestamp('2018-04-09 22:49:39'), 6], [21, Timestamp('2018-04-09 22:52:56'), Timestamp('2018-04-09 22:55:17'), 2], [21, Timestamp('2018-04-09 22:58:51'), Timestamp('2018-04-09 23:49:59'), 67], [21, Timestamp('2018-04-10 00:13:38'), Timestamp('2018-04-10 00:16:45'), 5], [21, Timestamp('2018-04-10 00:20:17'), Timestamp('2018-04-10 01:02:16'), 59], [21, Timestamp('2018-04-10 01:26:47'), Timestamp('2018-04-10 01:37:50'), 17], [2, Timestamp('2018-04-10 01:58:20'), Timestamp('2018-04-10 02:52:20'), 67], [2, Timestamp('2018-04-10 02:56:58'), Timestamp('2018-04-10 03:00:13'), 5], [2, Timestamp('2018-04-10 03:03:41'), Timestamp('2018-04-10 03:11:30'), 12], [2, Timestamp('2018-04-10 03:16:03'), Timestamp('2018-04-10 03:16:40'), 2], [2, Timestamp('2018-04-10 03:20:43'), Timestamp('2018-04-10 03:36:56'), 24], [2, Timestamp('2018-04-10 03:40:37'), Timestamp('2018-04-10 03:49:08'), 14], [3, Timestamp('2018-04-10 03:53:18'), Timestamp('2018-04-10 04:28:41'), 46], [3, Timestamp('2018-04-10 04:31:55'), Timestamp('2018-04-10 05:33:36'), 78], [6, Timestamp('2018-04-10 05:59:57'), Timestamp('2018-04-10 06:12:48'), 30], [6, Timestamp('2018-04-10 06:16:19'), Timestamp('2018-04-10 06:39:11'), 39], [6, Timestamp('2018-04-10 06:46:04'), Timestamp('2018-04-10 06:58:54'), 33], [6, Timestamp('2018-04-10 07:07:01'), Timestamp('2018-04-10 07:10:42'), 7], [6, Timestamp('2018-04-10 07:14:20'), Timestamp('2018-04-10 07:19:19'), 5], [6, Timestamp('2018-04-10 07:22:26'), Timestamp('2018-04-10 07:39:16'), 25], [6, Timestamp('2018-04-10 07:44:12'), Timestamp('2018-04-10 08:06:48'), 28], [6, Timestamp('2018-04-10 08:17:23'), Timestamp('2018-04-10 08:21:48'), 4], [6, Timestamp('2018-04-10 08:26:22'), Timestamp('2018-04-10 08:28:01'), 4], [7, Timestamp('2018-04-10 08:47:33'), Timestamp('2018-04-10 08:48:09'), 3], [7, Timestamp('2018-04-10 08:54:56'), Timestamp('2018-04-10 09:34:50'), 66], [7, Timestamp('2018-04-10 09:43:16'), Timestamp('2018-04-10 10:37:01'), 77], [7, Timestamp('2018-04-10 10:40:06'), Timestamp('2018-04-10 10:48:21'), 12], [7, Timestamp('2018-04-10 10:51:27'), Timestamp('2018-04-10 10:58:16'), 16], [10, Timestamp('2018-04-10 11:28:00'), Timestamp('2018-04-10 11:29:38'), 3], [10, Timestamp('2018-04-10 11:35:13'), Timestamp('2018-04-10 11:38:57'), 5], [10, Timestamp('2018-04-10 11:43:25'), Timestamp('2018-04-10 12:12:58'), 27], [10, Timestamp('2018-04-10 12:16:01'), Timestamp('2018-04-10 12:41:42'), 29], [10, Timestamp('2018-04-10 13:01:27'), Timestamp('2018-04-10 13:38:14'), 42], [12, Timestamp('2018-04-10 14:07:42'), Timestamp('2018-04-10 14:08:29'), 2], [12, Timestamp('2018-04-10 14:15:57'), Timestamp('2018-04-10 14:29:35'), 12], [12, Timestamp('2018-04-10 14:34:16'), Timestamp('2018-04-10 14:42:07'), 8], [12, Timestamp('2018-04-10 14:46:46'), Timestamp('2018-04-10 14:54:11'), 9], [12, Timestamp('2018-04-10 15:03:04'), Timestamp('2018-04-10 15:05:06'), 5], [12, Timestamp('2018-04-10 15:09:16'), Timestamp('2018-04-10 15:25:02'), 12], [12, Timestamp('2018-04-10 15:28:08'), Timestamp('2018-04-10 15:28:08'), 1], [12, Timestamp('2018-04-10 15:33:20'), Timestamp('2018-04-10 15:34:41'), 3], [12, Timestamp('2018-04-10 15:40:46'), Timestamp('2018-04-10 16:09:55'), 23], [12, Timestamp('2018-04-10 16:13:30'), Timestamp('2018-04-10 16:16:38'), 4], [12, Timestamp('2018-04-10 16:23:11'), Timestamp('2018-04-10 16:23:11'), 1], [12, Timestamp('2018-04-10 16:27:53'), Timestamp('2018-04-10 16:37:27'), 10], [12, Timestamp('2018-04-10 16:47:53'), Timestamp('2018-04-10 16:50:31'), 2], [12, Timestamp('2018-04-10 16:56:32'), Timestamp('2018-04-10 16:56:32'), 1], [12, Timestamp('2018-04-10 17:00:37'), Timestamp('2018-04-10 17:10:55'), 9], [12, Timestamp('2018-04-10 17:14:24'), Timestamp('2018-04-10 17:20:03'), 8], [12, Timestamp('2018-04-10 17:23:57'), Timestamp('2018-04-10 17:31:59'), 6], [12, Timestamp('2018-04-10 17:35:33'), Timestamp('2018-04-10 17:42:37'), 7], [12, Timestamp('2018-04-10 17:46:35'), Timestamp('2018-04-10 17:59:17'), 10], [8, Timestamp('2018-04-10 18:26:52'), Timestamp('2018-04-10 20:10:00'), 119], [1, Timestamp('2018-04-10 20:20:31'), Timestamp('2018-04-10 20:32:57'), 23], [1, Timestamp('2018-04-10 20:36:17'), Timestamp('2018-04-10 20:54:32'), 30], [1, Timestamp('2018-04-10 20:57:33'), Timestamp('2018-04-10 21:43:56'), 66], [16, Timestamp('2018-04-10 21:55:04'), Timestamp('2018-04-10 22:00:01'), 7], [16, Timestamp('2018-04-10 22:05:52'), Timestamp('2018-04-10 23:10:42'), 73], [18, Timestamp('2018-04-10 23:14:50'), Timestamp('2018-04-11 00:06:48'), 80], [2, Timestamp('2018-04-11 00:33:18'), Timestamp('2018-04-11 00:33:18'), 1], [2, Timestamp('2018-04-11 00:37:00'), Timestamp('2018-04-11 00:41:23'), 9], [2, Timestamp('2018-04-11 00:46:04'), Timestamp('2018-04-11 01:02:21'), 22], [2, Timestamp('2018-04-11 01:06:10'), Timestamp('2018-04-11 01:42:06'), 47], [13, Timestamp('2018-04-11 01:48:34'), Timestamp('2018-04-11 02:27:16'), 50], [13, Timestamp('2018-04-11 02:30:37'), Timestamp('2018-04-11 02:35:50'), 9], [13, Timestamp('2018-04-11 02:40:13'), Timestamp('2018-04-11 02:49:34'), 14], [13, Timestamp('2018-04-11 02:52:42'), Timestamp('2018-04-11 02:58:28'), 7], [3, Timestamp('2018-04-11 03:06:36'), Timestamp('2018-04-11 03:48:50'), 56], [3, Timestamp('2018-04-11 03:55:02'), Timestamp('2018-04-11 03:59:13'), 9], [3, Timestamp('2018-04-11 04:02:41'), Timestamp('2018-04-11 04:10:05'), 12], [3, Timestamp('2018-04-11 04:16:07'), Timestamp('2018-04-11 04:16:28'), 2], [14, Timestamp('2018-04-11 04:20:18'), Timestamp('2018-04-11 04:26:43'), 7], [14, Timestamp('2018-04-11 04:30:47'), Timestamp('2018-04-11 05:29:14'), 73], [4, Timestamp('2018-04-11 05:33:49'), Timestamp('2018-04-11 05:48:31'), 20], [4, Timestamp('2018-04-11 05:52:20'), Timestamp('2018-04-11 06:21:33'), 42], [4, Timestamp('2018-04-11 06:27:43'), Timestamp('2018-04-11 06:31:35'), 7], [4, Timestamp('2018-04-11 06:35:24'), Timestamp('2018-04-11 06:43:20'), 13], [4, Timestamp('2018-04-11 06:49:05'), Timestamp('2018-04-11 07:07:02'), 29], [4, Timestamp('2018-04-11 07:12:19'), Timestamp('2018-04-11 07:20:04'), 14], [5, Timestamp('2018-04-11 07:21:57'), Timestamp('2018-04-11 07:28:13'), 6], [5, Timestamp('2018-04-11 07:33:37'), Timestamp('2018-04-11 08:35:26'), 78], [5, Timestamp('2018-04-11 08:48:37'), Timestamp('2018-04-11 09:12:51'), 41], [4, Timestamp('2018-04-11 09:19:30'), Timestamp('2018-04-11 09:35:39'), 21], [4, Timestamp('2018-04-11 09:39:45'), Timestamp('2018-04-11 10:23:54'), 57], [4, Timestamp('2018-04-11 10:32:33'), Timestamp('2018-04-11 10:57:42'), 38], [4, Timestamp('2018-04-11 11:04:49'), Timestamp('2018-04-11 11:05:45'), 3], [4, Timestamp('2018-04-11 11:11:13'), Timestamp('2018-04-11 11:13:37'), 6], [5, Timestamp('2018-04-11 11:27:55'), Timestamp('2018-04-11 12:23:34'), 66], [5, Timestamp('2018-04-11 12:27:14'), Timestamp('2018-04-11 13:17:00'), 59], [9, Timestamp('2018-04-11 13:27:01'), Timestamp('2018-04-11 14:33:15'), 91], [9, Timestamp('2018-04-11 14:36:34'), Timestamp('2018-04-11 14:40:24'), 9], [11, Timestamp('2018-04-11 14:53:15'), Timestamp('2018-04-11 15:50:33'), 76], [11, Timestamp('2018-04-11 15:54:10'), Timestamp('2018-04-11 16:10:00'), 24], [6, Timestamp('2018-04-11 16:22:20'), Timestamp('2018-04-11 16:27:55'), 13], [6, Timestamp('2018-04-11 16:33:54'), Timestamp('2018-04-11 16:44:43'), 24], [6, Timestamp('2018-04-11 16:49:51'), Timestamp('2018-04-11 17:11:52'), 44], [6, Timestamp('2018-04-11 17:15:13'), Timestamp('2018-04-11 17:41:08'), 49], [6, Timestamp('2018-04-11 17:48:07'), Timestamp('2018-04-11 18:45:41'), 95], [6, Timestamp('2018-04-11 18:48:51'), Timestamp('2018-04-11 18:56:07'), 15], [7, Timestamp('2018-04-11 19:10:44'), Timestamp('2018-04-11 19:38:39'), 42], [7, Timestamp('2018-04-11 19:45:17'), Timestamp('2018-04-11 20:07:00'), 33], [7, Timestamp('2018-04-11 20:13:33'), Timestamp('2018-04-11 20:44:55'), 46], [7, Timestamp('2018-04-11 20:49:09'), Timestamp('2018-04-11 20:58:31'), 22], [7, Timestamp('2018-04-11 21:01:32'), Timestamp('2018-04-11 21:07:34'), 7], [7, Timestamp('2018-04-11 21:14:40'), Timestamp('2018-04-11 21:39:17'), 45], [7, Timestamp('2018-04-11 21:42:37'), Timestamp('2018-04-11 21:45:32'), 11], [7, Timestamp('2018-04-11 21:48:34'), Timestamp('2018-04-11 22:06:14'), 33], [10, Timestamp('2018-04-11 22:20:31'), Timestamp('2018-04-11 23:25:41'), 68], [10, Timestamp('2018-04-11 23:29:26'), Timestamp('2018-04-11 23:32:53'), 5], [10, Timestamp('2018-04-11 23:39:39'), Timestamp('2018-04-11 23:42:44'), 6], [12, Timestamp('2018-04-12 00:02:35'), Timestamp('2018-04-12 00:04:40'), 4], [12, Timestamp('2018-04-12 00:21:06'), Timestamp('2018-04-12 00:21:06'), 1], [12, Timestamp('2018-04-12 00:25:17'), Timestamp('2018-04-12 01:10:37'), 40], [12, Timestamp('2018-04-12 01:13:46'), Timestamp('2018-04-12 01:20:59'), 8], [12, Timestamp('2018-04-12 01:24:11'), Timestamp('2018-04-12 01:29:02'), 6], [12, Timestamp('2018-04-12 01:33:03'), Timestamp('2018-04-12 01:37:06'), 6], [12, Timestamp('2018-04-12 01:41:09'), Timestamp('2018-04-12 01:55:43'), 13], [8, Timestamp('2018-04-12 02:25:42'), Timestamp('2018-04-12 02:51:49'), 30], [8, Timestamp('2018-04-12 02:55:17'), Timestamp('2018-04-12 02:59:08'), 4], [8, Timestamp('2018-04-12 03:02:12'), Timestamp('2018-04-12 03:17:14'), 13], [8, Timestamp('2018-04-12 03:23:39'), Timestamp('2018-04-12 03:24:36'), 2], [8, Timestamp('2018-04-12 03:29:32'), Timestamp('2018-04-12 03:37:32'), 10], [8, Timestamp('2018-04-12 03:40:47'), Timestamp('2018-04-12 03:56:08'), 19], [8, Timestamp('2018-04-12 03:59:40'), Timestamp('2018-04-12 04:01:31'), 3], [8, Timestamp('2018-04-12 04:06:17'), Timestamp('2018-04-12 04:13:11'), 9], [8, Timestamp('2018-04-12 04:19:04'), Timestamp('2018-04-12 04:44:02'), 28], [1, Timestamp('2018-04-12 04:55:01'), Timestamp('2018-04-12 05:23:11'), 42], [1, Timestamp('2018-04-12 05:26:31'), Timestamp('2018-04-12 05:30:30'), 4], [1, Timestamp('2018-04-12 05:38:52'), Timestamp('2018-04-12 05:39:18'), 2], [1, Timestamp('2018-04-12 05:43:29'), Timestamp('2018-04-12 06:29:08'), 62], [1, Timestamp('2018-04-12 06:34:36'), Timestamp('2018-04-12 06:39:02'), 7], [8, Timestamp('2018-04-12 06:58:06'), Timestamp('2018-04-12 07:00:41'), 4], [8, Timestamp('2018-04-12 07:05:31'), Timestamp('2018-04-12 07:25:24'), 24], [8, Timestamp('2018-04-12 07:44:11'), Timestamp('2018-04-12 07:50:40'), 7], [8, Timestamp('2018-04-12 07:57:38'), Timestamp('2018-04-12 07:57:38'), 1], [8, Timestamp('2018-04-12 08:03:04'), Timestamp('2018-04-12 08:25:18'), 29], [8, Timestamp('2018-04-12 11:43:30'), Timestamp('2018-04-12 11:44:00'), 2], [8, Timestamp('2018-04-12 11:48:06'), Timestamp('2018-04-12 11:48:06'), 1], [8, Timestamp('2018-04-12 12:05:11'), Timestamp('2018-04-12 12:11:06'), 10], [8, Timestamp('2018-04-12 12:16:10'), Timestamp('2018-04-12 12:16:10'), 1], [8, Timestamp('2018-04-12 12:20:56'), Timestamp('2018-04-12 12:27:19'), 9], [8, Timestamp('2018-04-12 12:31:58'), Timestamp('2018-04-12 12:31:58'), 1], [8, Timestamp('2018-04-12 12:42:12'), Timestamp('2018-04-12 12:45:46'), 5], [8, Timestamp('2018-04-12 12:49:51'), Timestamp('2018-04-12 13:01:03'), 13], [8, Timestamp('2018-04-12 13:19:20'), Timestamp('2018-04-12 13:25:52'), 9], [8, Timestamp('2018-04-12 13:39:47'), Timestamp('2018-04-12 13:40:39'), 3], [1, Timestamp('2018-04-12 13:43:36'), Timestamp('2018-04-12 13:44:07'), 2], [1, Timestamp('2018-04-12 13:51:19'), Timestamp('2018-04-12 13:53:10'), 4], [1, Timestamp('2018-04-12 14:34:59'), Timestamp('2018-04-12 14:34:59'), 1], [8, Timestamp('2018-04-12 14:35:18'), Timestamp('2018-04-12 14:35:18'), 1], [1, Timestamp('2018-04-12 14:35:57'), Timestamp('2018-04-12 14:37:43'), 4], [1, Timestamp('2018-04-12 14:41:34'), Timestamp('2018-04-12 14:51:23'), 8], [1, Timestamp('2018-04-12 14:55:07'), Timestamp('2018-04-12 15:21:13'), 28], [1, Timestamp('2018-04-12 15:27:32'), Timestamp('2018-04-12 15:27:56'), 2], [1, Timestamp('2018-04-12 15:52:39'), Timestamp('2018-04-12 15:56:41'), 6], [1, Timestamp('2018-04-12 16:02:28'), Timestamp('2018-04-12 16:35:20'), 39], [1, Timestamp('2018-04-12 16:40:35'), Timestamp('2018-04-12 16:56:31'), 26], [4, Timestamp('2018-04-12 17:29:57'), Timestamp('2018-04-12 18:47:11'), 97], [4, Timestamp('2018-04-12 18:52:48'), Timestamp('2018-04-12 20:06:37'), 92], [4, Timestamp('2018-04-12 20:10:45'), Timestamp('2018-04-12 20:15:33'), 9], [5, Timestamp('2018-04-12 20:23:04'), Timestamp('2018-04-12 21:14:51'), 65], [5, Timestamp('2018-04-12 21:18:06'), Timestamp('2018-04-12 21:23:23'), 8], [5, Timestamp('2018-04-12 21:26:51'), Timestamp('2018-04-12 21:28:25'), 3], [5, Timestamp('2018-04-12 21:32:40'), Timestamp('2018-04-12 22:16:48'), 57], [5, Timestamp('2018-04-12 22:19:56'), Timestamp('2018-04-12 22:37:57'), 24], [5, Timestamp('2018-04-12 22:45:45'), Timestamp('2018-04-12 23:19:52'), 39], [5, Timestamp('2018-04-12 23:23:17'), Timestamp('2018-04-12 23:23:17'), 1], [2, Timestamp('2018-04-12 23:32:32'), Timestamp('2018-04-13 00:12:34'), 39], [2, Timestamp('2018-04-13 00:16:54'), Timestamp('2018-04-13 00:16:54'), 1], [2, Timestamp('2018-04-13 00:20:05'), Timestamp('2018-04-13 00:41:16'), 24], [2, Timestamp('2018-04-13 00:44:45'), Timestamp('2018-04-13 00:56:33'), 19], [2, Timestamp('2018-04-13 01:01:24'), Timestamp('2018-04-13 01:06:11'), 8], [2, Timestamp('2018-04-13 01:09:14'), Timestamp('2018-04-13 01:15:11'), 12], [2, Timestamp('2018-04-13 01:18:53'), Timestamp('2018-04-13 01:31:12'), 17], [3, Timestamp('2018-04-13 01:34:43'), Timestamp('2018-04-13 01:45:46'), 17], [3, Timestamp('2018-04-13 01:50:43'), Timestamp('2018-04-13 02:23:52'), 48], [3, Timestamp('2018-04-13 02:30:34'), Timestamp('2018-04-13 03:00:15'), 36], [3, Timestamp('2018-04-13 03:03:35'), Timestamp('2018-04-13 03:09:42'), 11], [3, Timestamp('2018-04-13 03:12:46'), Timestamp('2018-04-13 03:18:38'), 8], [22, Timestamp('2018-04-13 03:57:59'), Timestamp('2018-04-13 04:35:03'), 53], [22, Timestamp('2018-04-13 04:38:11'), Timestamp('2018-04-13 05:01:17'), 27], [8, Timestamp('2018-04-13 05:05:21'), Timestamp('2018-04-13 06:24:04'), 91], [8, Timestamp('2018-04-13 06:29:02'), Timestamp('2018-04-13 06:53:02'), 28], [23, Timestamp('2018-04-13 07:01:38'), Timestamp('2018-04-13 07:11:11'), 16], [23, Timestamp('2018-04-13 07:17:23'), Timestamp('2018-04-13 07:44:57'), 37], [23, Timestamp('2018-04-13 07:48:23'), Timestamp('2018-04-13 08:12:21'), 26], [1, Timestamp('2018-04-13 08:44:07'), Timestamp('2018-04-13 08:50:02'), 9], [1, Timestamp('2018-04-13 08:53:07'), Timestamp('2018-04-13 09:12:41'), 29], [1, Timestamp('2018-04-13 09:15:45'), Timestamp('2018-04-13 09:38:33'), 37], [1, Timestamp('2018-04-13 09:45:32'), Timestamp('2018-04-13 10:13:45'), 46], [17, Timestamp('2018-04-13 10:26:09'), Timestamp('2018-04-13 10:26:09'), 1], [1, Timestamp('2018-04-13 10:27:01'), Timestamp('2018-04-13 10:27:01'), 1], [8, Timestamp('2018-04-13 10:42:47'), Timestamp('2018-04-13 10:42:47'), 1], [8, Timestamp('2018-04-13 10:48:29'), Timestamp('2018-04-13 11:01:17'), 16], [8, Timestamp('2018-04-13 11:06:48'), Timestamp('2018-04-13 11:29:09'), 27], [8, Timestamp('2018-04-13 11:34:51'), Timestamp('2018-04-13 11:59:25'), 27], [8, Timestamp('2018-04-13 12:02:44'), Timestamp('2018-04-13 12:29:18'), 29], [8, Timestamp('2018-04-13 12:34:11'), Timestamp('2018-04-13 12:45:57'), 14], [8, Timestamp('2018-04-13 12:49:09'), Timestamp('2018-04-13 12:53:31'), 6], [1, Timestamp('2018-04-13 12:55:27'), Timestamp('2018-04-13 12:55:27'), 1], [1, Timestamp('2018-04-13 12:58:32'), Timestamp('2018-04-13 13:06:04'), 12], [1, Timestamp('2018-04-13 13:10:08'), Timestamp('2018-04-13 13:23:13'), 19], [1, Timestamp('2018-04-13 13:26:15'), Timestamp('2018-04-13 13:35:52'), 15], [1, Timestamp('2018-04-13 13:40:23'), Timestamp('2018-04-13 13:59:10'), 27], [1, Timestamp('2018-04-13 14:05:13'), Timestamp('2018-04-13 14:13:34'), 17], [1, Timestamp('2018-04-13 14:20:24'), Timestamp('2018-04-13 14:27:35'), 8], [1, Timestamp('2018-04-13 14:32:15'), Timestamp('2018-04-13 14:44:25'), 19], [1, Timestamp('2018-04-13 14:49:13'), Timestamp('2018-04-13 14:49:41'), 2], [6, Timestamp('2018-04-13 15:21:15'), Timestamp('2018-04-13 15:30:22'), 21], [6, Timestamp('2018-04-13 15:33:25'), Timestamp('2018-04-13 15:38:47'), 10], [6, Timestamp('2018-04-13 15:47:31'), Timestamp('2018-04-13 15:50:52'), 5], [6, Timestamp('2018-04-13 15:55:21'), Timestamp('2018-04-13 15:59:11'), 6], [6, Timestamp('2018-04-13 16:04:27'), Timestamp('2018-04-13 16:47:20'), 69], [6, Timestamp('2018-04-13 16:54:52'), Timestamp('2018-04-13 16:56:40'), 10], [6, Timestamp('2018-04-13 17:01:58'), Timestamp('2018-04-13 17:08:21'), 17], [6, Timestamp('2018-04-13 17:12:45'), Timestamp('2018-04-13 17:15:16'), 7], [6, Timestamp('2018-04-13 17:23:25'), Timestamp('2018-04-13 17:32:43'), 20], [24, Timestamp('2018-04-13 17:38:02'), Timestamp('2018-04-13 18:10:20'), 54], [24, Timestamp('2018-04-13 18:14:14'), Timestamp('2018-04-13 18:33:14'), 36], [24, Timestamp('2018-04-13 18:38:32'), Timestamp('2018-04-13 19:26:06'), 78], [7, Timestamp('2018-04-13 19:39:56'), Timestamp('2018-04-13 20:46:33'), 116], [7, Timestamp('2018-04-13 20:49:45'), Timestamp('2018-04-13 21:20:39'), 50], [25, Timestamp('2018-04-13 21:31:15'), Timestamp('2018-04-13 22:23:38'), 83], [25, Timestamp('2018-04-13 22:28:35'), Timestamp('2018-04-13 23:19:23'), 85], [10, Timestamp('2018-04-13 23:30:45'), Timestamp('2018-04-14 00:08:23'), 43], [10, Timestamp('2018-04-14 00:15:07'), Timestamp('2018-04-14 00:34:07'), 20], [10, Timestamp('2018-04-14 00:37:49'), Timestamp('2018-04-14 00:37:49'), 1], [10, Timestamp('2018-04-14 00:44:09'), Timestamp('2018-04-14 00:50:16'), 12], [10, Timestamp('2018-04-14 00:54:54'), Timestamp('2018-04-14 00:58:32'), 4], [12, Timestamp('2018-04-14 01:13:18'), Timestamp('2018-04-14 01:16:01'), 5], [12, Timestamp('2018-04-14 01:20:56'), Timestamp('2018-04-14 01:23:32'), 4], [12, Timestamp('2018-04-14 01:27:00'), Timestamp('2018-04-14 01:27:00'), 1], [12, Timestamp('2018-04-14 01:30:15'), Timestamp('2018-04-14 01:32:12'), 4], [12, Timestamp('2018-04-14 01:36:59'), Timestamp('2018-04-14 01:50:16'), 11], [12, Timestamp('2018-04-14 01:56:33'), Timestamp('2018-04-14 02:24:49'), 24], [12, Timestamp('2018-04-14 02:29:48'), Timestamp('2018-04-14 02:31:43'), 4], [12, Timestamp('2018-04-14 02:53:36'), Timestamp('2018-04-14 03:00:14'), 12], [12, Timestamp('2018-04-14 03:05:35'), Timestamp('2018-04-14 03:10:31'), 8], [12, Timestamp('2018-04-14 03:15:04'), Timestamp('2018-04-14 03:15:04'), 1], [12, Timestamp('2018-04-14 03:31:19'), Timestamp('2018-04-14 03:34:07'), 6], [13, Timestamp('2018-04-14 03:48:32'), Timestamp('2018-04-14 04:21:58'), 42], [13, Timestamp('2018-04-14 04:35:57'), Timestamp('2018-04-14 04:42:14'), 9], [13, Timestamp('2018-04-14 04:53:08'), Timestamp('2018-04-14 04:57:27'), 7], [13, Timestamp('2018-04-14 05:00:36'), Timestamp('2018-04-14 05:37:30'), 51], [13, Timestamp('2018-04-14 05:42:09'), Timestamp('2018-04-14 05:42:44'), 2], [13, Timestamp('2018-04-14 05:46:30'), Timestamp('2018-04-14 05:56:53'), 14], [14, Timestamp('2018-04-14 06:04:07'), Timestamp('2018-04-14 06:24:01'), 26], [14, Timestamp('2018-04-14 06:37:57'), Timestamp('2018-04-14 06:48:40'), 21], [14, Timestamp('2018-04-14 06:53:14'), Timestamp('2018-04-14 07:25:39'), 43], [14, Timestamp('2018-04-14 07:29:59'), Timestamp('2018-04-14 07:36:02'), 11], [14, Timestamp('2018-04-14 07:42:05'), Timestamp('2018-04-14 07:59:13'), 24], [4, Timestamp('2018-04-14 08:14:32'), Timestamp('2018-04-14 08:37:25'), 34], [4, Timestamp('2018-04-14 08:44:03'), Timestamp('2018-04-14 08:56:34'), 20], [4, Timestamp('2018-04-14 09:00:51'), Timestamp('2018-04-14 09:33:52'), 49], [4, Timestamp('2018-04-14 09:39:05'), Timestamp('2018-04-14 09:46:11'), 13], [4, Timestamp('2018-04-14 09:49:24'), Timestamp('2018-04-14 09:53:08'), 7], [5, Timestamp('2018-04-14 10:12:37'), Timestamp('2018-04-14 10:13:55'), 6], [5, Timestamp('2018-04-14 10:18:01'), Timestamp('2018-04-14 10:24:42'), 8], [5, Timestamp('2018-04-14 10:29:03'), Timestamp('2018-04-14 10:49:39'), 30], [5, Timestamp('2018-04-14 10:54:14'), Timestamp('2018-04-14 10:59:38'), 10], [5, Timestamp('2018-04-14 11:03:09'), Timestamp('2018-04-14 11:11:04'), 9], [5, Timestamp('2018-04-14 11:14:56'), Timestamp('2018-04-14 11:25:46'), 18], [5, Timestamp('2018-04-14 11:31:25'), Timestamp('2018-04-14 11:46:16'), 16], [5, Timestamp('2018-04-14 11:53:49'), Timestamp('2018-04-14 12:04:32'), 15], [5, Timestamp('2018-04-14 12:14:32'), Timestamp('2018-04-14 12:18:05'), 10], [4, Timestamp('2018-04-14 12:22:23'), Timestamp('2018-04-14 12:49:53'), 37], [4, Timestamp('2018-04-14 12:53:46'), Timestamp('2018-04-14 13:16:41'), 32], [4, Timestamp('2018-04-14 13:22:46'), Timestamp('2018-04-14 13:39:04'), 21], [4, Timestamp('2018-04-14 13:43:45'), Timestamp('2018-04-14 14:06:08'), 35], [5, Timestamp('2018-04-14 14:08:43'), Timestamp('2018-04-14 14:12:37'), 4], [5, Timestamp('2018-04-14 14:15:48'), Timestamp('2018-04-14 15:05:49'), 59], [5, Timestamp('2018-04-14 15:10:01'), Timestamp('2018-04-14 16:02:42'), 62], [5, Timestamp('2018-04-14 16:05:47'), Timestamp('2018-04-14 16:05:47'), 1], [9, Timestamp('2018-04-14 16:08:05'), Timestamp('2018-04-14 16:34:24'), 37], [9, Timestamp('2018-04-14 16:40:47'), Timestamp('2018-04-14 16:46:14'), 10], [9, Timestamp('2018-04-14 16:50:37'), Timestamp('2018-04-14 16:58:02'), 14], [9, Timestamp('2018-04-14 17:06:01'), Timestamp('2018-04-14 17:12:27'), 13], [9, Timestamp('2018-04-14 17:18:49'), Timestamp('2018-04-14 17:21:45'), 7], [11, Timestamp('2018-04-14 17:25:31'), Timestamp('2018-04-14 18:25:42'), 81], [6, Timestamp('2018-04-14 18:36:53'), Timestamp('2018-04-14 19:16:15'), 84], [6, Timestamp('2018-04-14 19:19:26'), Timestamp('2018-04-14 19:30:37'), 22], [6, Timestamp('2018-04-14 19:38:26'), Timestamp('2018-04-14 19:42:40'), 11], [6, Timestamp('2018-04-14 19:45:41'), Timestamp('2018-04-14 19:55:59'), 20], [6, Timestamp('2018-04-14 20:02:26'), Timestamp('2018-04-14 20:03:47'), 5], [6, Timestamp('2018-04-14 20:09:44'), Timestamp('2018-04-14 20:09:44'), 1], [6, Timestamp('2018-04-14 20:15:58'), Timestamp('2018-04-14 20:35:13'), 31], [7, Timestamp('2018-04-14 20:36:57'), Timestamp('2018-04-14 20:41:32'), 8], [7, Timestamp('2018-04-14 20:47:38'), Timestamp('2018-04-14 22:21:48'), 159], [7, Timestamp('2018-04-14 22:27:19'), Timestamp('2018-04-14 22:29:40'), 7], [19, Timestamp('2018-04-14 23:08:28'), Timestamp('2018-04-14 23:28:46'), 37], [19, Timestamp('2018-04-14 23:31:47'), Timestamp('2018-04-14 23:31:47'), 1], [19, Timestamp('2018-04-14 23:35:15'), Timestamp('2018-04-14 23:35:15'), 1], [8, Timestamp('2018-04-14 23:55:34'), Timestamp('2018-04-15 01:39:48'), 119], [1, Timestamp('2018-04-15 01:46:43'), Timestamp('2018-04-15 02:10:21'), 33], [1, Timestamp('2018-04-15 02:15:29'), Timestamp('2018-04-15 02:24:29'), 20], [1, Timestamp('2018-04-15 02:29:00'), Timestamp('2018-04-15 03:15:18'), 66], [21, Timestamp('2018-04-15 03:56:39'), Timestamp('2018-04-15 03:56:53'), 2], [21, Timestamp('2018-04-15 04:01:27'), Timestamp('2018-04-15 04:02:57'), 3], [21, Timestamp('2018-04-15 04:07:03'), Timestamp('2018-04-15 04:15:07'), 16], [21, Timestamp('2018-04-15 04:18:11'), Timestamp('2018-04-15 04:40:59'), 31], [21, Timestamp('2018-04-15 04:45:45'), Timestamp('2018-04-15 04:50:00'), 10], [19, Timestamp('2018-04-15 04:56:51'), Timestamp('2018-04-15 05:00:32'), 8], [19, Timestamp('2018-04-15 05:04:52'), Timestamp('2018-04-15 06:07:31'), 92], [21, Timestamp('2018-04-15 06:22:35'), Timestamp('2018-04-15 06:52:53'), 37], [21, Timestamp('2018-04-15 06:56:15'), Timestamp('2018-04-15 06:58:52'), 8], [21, Timestamp('2018-04-15 07:04:19'), Timestamp('2018-04-15 07:42:39'), 56], [16, Timestamp('2018-04-15 07:48:54'), Timestamp('2018-04-15 08:10:19'), 24], [16, Timestamp('2018-04-15 08:13:58'), Timestamp('2018-04-15 08:20:06'), 7], [16, Timestamp('2018-04-15 08:25:27'), Timestamp('2018-04-15 08:39:55'), 17], [16, Timestamp('2018-04-15 08:44:45'), Timestamp('2018-04-15 09:40:49'), 62], [16, Timestamp('2018-04-15 09:45:38'), Timestamp('2018-04-15 09:56:41'), 14], [16, Timestamp('2018-04-15 10:03:12'), Timestamp('2018-04-15 10:13:50'), 14], [16, Timestamp('2018-04-15 10:17:06'), Timestamp('2018-04-15 10:17:06'), 1], [18, Timestamp('2018-04-15 10:18:06'), Timestamp('2018-04-15 10:47:46'), 38], [18, Timestamp('2018-04-15 10:53:21'), Timestamp('2018-04-15 11:03:09'), 21], [18, Timestamp('2018-04-15 11:09:28'), Timestamp('2018-04-15 11:18:16'), 14], [18, Timestamp('2018-04-15 11:24:59'), Timestamp('2018-04-15 11:39:49'), 21], [18, Timestamp('2018-04-15 11:53:38'), Timestamp('2018-04-15 11:58:41'), 11], [18, Timestamp('2018-04-15 12:03:46'), Timestamp('2018-04-15 12:06:34'), 6], [18, Timestamp('2018-04-15 12:12:54'), Timestamp('2018-04-15 12:17:03'), 11], [18, Timestamp('2018-04-15 12:24:38'), Timestamp('2018-04-15 12:25:43'), 6], [18, Timestamp('2018-04-15 12:29:49'), Timestamp('2018-04-15 12:38:41'), 10], [16, Timestamp('2018-04-15 12:43:29'), Timestamp('2018-04-15 13:51:56'), 71], [16, Timestamp('2018-04-15 13:56:20'), Timestamp('2018-04-15 14:04:47'), 11], [16, Timestamp('2018-04-15 14:10:00'), Timestamp('2018-04-15 15:04:36'), 65], [16, Timestamp('2018-04-15 15:09:54'), Timestamp('2018-04-15 15:20:26'), 13], [18, Timestamp('2018-04-15 15:23:01'), Timestamp('2018-04-15 15:33:22'), 15], [18, Timestamp('2018-04-15 15:38:10'), Timestamp('2018-04-15 15:41:51'), 6], [18, Timestamp('2018-04-15 15:45:39'), Timestamp('2018-04-15 15:46:35'), 4], [18, Timestamp('2018-04-15 15:58:28'), Timestamp('2018-04-15 16:21:58'), 32], [18, Timestamp('2018-04-15 16:27:52'), Timestamp('2018-04-15 16:30:36'), 10], [18, Timestamp('2018-04-15 16:36:58'), Timestamp('2018-04-15 16:48:17'), 19], [18, Timestamp('2018-04-15 16:52:01'), Timestamp('2018-04-15 17:43:46'), 73], [10, Timestamp('2018-04-15 18:00:14'), Timestamp('2018-04-15 18:05:03'), 7], [10, Timestamp('2018-04-15 18:11:23'), Timestamp('2018-04-15 18:37:57'), 31], [10, Timestamp('2018-04-15 18:43:39'), Timestamp('2018-04-15 18:43:39'), 1], [10, Timestamp('2018-04-15 18:48:02'), Timestamp('2018-04-15 19:50:22'), 70], [10, Timestamp('2018-04-15 19:56:23'), Timestamp('2018-04-15 19:56:23'), 1], [10, Timestamp('2018-04-15 20:12:53'), Timestamp('2018-04-15 20:52:44'), 50], [12, Timestamp('2018-04-15 21:06:40'), Timestamp('2018-04-15 21:08:00'), 3], [12, Timestamp('2018-04-15 21:12:23'), Timestamp('2018-04-15 21:19:52'), 7], [12, Timestamp('2018-04-15 21:23:53'), Timestamp('2018-04-15 21:33:17'), 10], [12, Timestamp('2018-04-15 21:37:10'), Timestamp('2018-04-15 21:39:53'), 6], [12, Timestamp('2018-04-15 21:44:14'), Timestamp('2018-04-15 22:01:44'), 14], [12, Timestamp('2018-04-15 22:05:56'), Timestamp('2018-04-15 22:07:37'), 2], [12, Timestamp('2018-04-15 22:10:50'), Timestamp('2018-04-15 22:14:54'), 3], [12, Timestamp('2018-04-15 22:18:46'), Timestamp('2018-04-15 22:20:54'), 3], [12, Timestamp('2018-04-15 22:40:17'), Timestamp('2018-04-15 22:52:52'), 11], [12, Timestamp('2018-04-15 22:58:29'), Timestamp('2018-04-15 23:00:44'), 4], [12, Timestamp('2018-04-15 23:05:25'), Timestamp('2018-04-15 23:10:54'), 5], [12, Timestamp('2018-04-15 23:14:55'), Timestamp('2018-04-15 23:36:10'), 20], [12, Timestamp('2018-04-15 23:39:28'), Timestamp('2018-04-15 23:41:08'), 4], [12, Timestamp('2018-04-15 23:44:51'), Timestamp('2018-04-15 23:48:18'), 5], [12, Timestamp('2018-04-15 23:52:09'), Timestamp('2018-04-16 00:07:12'), 15], [12, Timestamp('2018-04-16 00:11:22'), Timestamp('2018-04-16 00:11:22'), 1], [12, Timestamp('2018-04-16 00:26:31'), Timestamp('2018-04-16 00:28:42'), 3], [12, Timestamp('2018-04-16 00:35:58'), Timestamp('2018-04-16 00:35:58'), 1], [12, Timestamp('2018-04-16 00:39:21'), Timestamp('2018-04-16 00:53:45'), 15], [12, Timestamp('2018-04-16 00:59:01'), Timestamp('2018-04-16 01:06:32'), 12], [12, Timestamp('2018-04-16 01:12:02'), Timestamp('2018-04-16 01:12:49'), 3], [12, Timestamp('2018-04-16 01:18:27'), Timestamp('2018-04-16 01:36:07'), 13], [4, Timestamp('2018-04-16 01:47:50'), Timestamp('2018-04-16 01:52:55'), 11], [4, Timestamp('2018-04-16 01:56:34'), Timestamp('2018-04-16 01:59:12'), 4], [4, Timestamp('2018-04-16 02:03:22'), Timestamp('2018-04-16 02:05:08'), 3], [4, Timestamp('2018-04-16 02:08:19'), Timestamp('2018-04-16 02:42:02'), 51], [4, Timestamp('2018-04-16 02:45:34'), Timestamp('2018-04-16 02:56:55'), 13], [4, Timestamp('2018-04-16 03:05:01'), Timestamp('2018-04-16 03:06:39'), 3], [4, Timestamp('2018-04-16 03:09:58'), Timestamp('2018-04-16 03:15:28'), 5], [4, Timestamp('2018-04-16 03:23:34'), Timestamp('2018-04-16 03:41:22'), 27], [4, Timestamp('2018-04-16 03:44:46'), Timestamp('2018-04-16 04:10:00'), 39], [4, Timestamp('2018-04-16 04:14:32'), Timestamp('2018-04-16 04:22:25'), 12], [4, Timestamp('2018-04-16 04:26:38'), Timestamp('2018-04-16 04:49:05'), 37], [4, Timestamp('2018-04-16 04:53:26'), Timestamp('2018-04-16 04:59:00'), 10], [4, Timestamp('2018-04-16 05:02:21'), Timestamp('2018-04-16 05:02:52'), 2], [4, Timestamp('2018-04-16 05:07:25'), Timestamp('2018-04-16 05:13:24'), 11], [4, Timestamp('2018-04-16 05:18:00'), Timestamp('2018-04-16 05:23:19'), 9], [5, Timestamp('2018-04-16 05:29:21'), Timestamp('2018-04-16 05:33:35'), 8], [5, Timestamp('2018-04-16 05:37:10'), Timestamp('2018-04-16 06:13:51'), 50], [5, Timestamp('2018-04-16 06:18:09'), Timestamp('2018-04-16 06:52:48'), 42], [5, Timestamp('2018-04-16 07:04:50'), Timestamp('2018-04-16 07:42:26'), 59], [5, Timestamp('2018-04-16 07:49:02'), Timestamp('2018-04-16 08:01:40'), 18], [5, Timestamp('2018-04-16 08:08:26'), Timestamp('2018-04-16 08:32:13'), 28], [5, Timestamp('2018-04-16 08:36:34'), Timestamp('2018-04-16 08:58:05'), 32], [2, Timestamp('2018-04-16 09:02:14'), Timestamp('2018-04-16 09:15:36'), 15], [2, Timestamp('2018-04-16 09:18:46'), Timestamp('2018-04-16 09:38:01'), 28], [2, Timestamp('2018-04-16 09:41:03'), Timestamp('2018-04-16 09:52:37'), 18], [2, Timestamp('2018-04-16 09:59:59'), Timestamp('2018-04-16 10:12:09'), 19], [2, Timestamp('2018-04-16 10:18:10'), Timestamp('2018-04-16 10:21:45'), 8], [4, Timestamp('2018-04-16 10:24:13'), Timestamp('2018-04-16 10:31:40'), 6], [4, Timestamp('2018-04-16 10:35:39'), Timestamp('2018-04-16 11:20:47'), 62], [4, Timestamp('2018-04-16 11:26:06'), Timestamp('2018-04-16 11:26:06'), 1], [3, Timestamp('2018-04-16 11:28:41'), Timestamp('2018-04-16 11:32:54'), 4], [3, Timestamp('2018-04-16 11:37:06'), Timestamp('2018-04-16 11:42:18'), 7], [3, Timestamp('2018-04-16 11:46:46'), Timestamp('2018-04-16 12:09:19'), 30], [3, Timestamp('2018-04-16 12:12:25'), Timestamp('2018-04-16 12:15:29'), 5], [3, Timestamp('2018-04-16 12:19:10'), Timestamp('2018-04-16 12:28:46'), 15], [3, Timestamp('2018-04-16 12:43:17'), Timestamp('2018-04-16 13:03:41'), 27], [5, Timestamp('2018-04-16 13:05:29'), Timestamp('2018-04-16 13:38:52'), 45], [5, Timestamp('2018-04-16 13:44:24'), Timestamp('2018-04-16 13:58:56'), 16], [5, Timestamp('2018-04-16 14:02:05'), Timestamp('2018-04-16 14:08:10'), 8], [20, Timestamp('2018-04-16 15:06:42'), Timestamp('2018-04-16 15:06:42'), 1], [20, Timestamp('2018-04-16 15:13:44'), Timestamp('2018-04-16 15:13:44'), 1], [20, Timestamp('2018-04-16 15:17:27'), Timestamp('2018-04-16 15:19:29'), 3], [20, Timestamp('2018-04-16 15:23:19'), Timestamp('2018-04-16 16:44:32'), 82], [20, Timestamp('2018-04-16 16:58:35'), Timestamp('2018-04-16 17:05:14'), 5], [20, Timestamp('2018-04-16 17:08:17'), Timestamp('2018-04-16 17:16:08'), 10], [20, Timestamp('2018-04-16 17:26:24'), Timestamp('2018-04-16 17:50:30'), 24], [20, Timestamp('2018-04-16 17:53:43'), Timestamp('2018-04-16 17:56:29'), 3], [20, Timestamp('2018-04-16 17:59:36'), Timestamp('2018-04-16 17:59:36'), 1], [20, Timestamp('2018-04-16 18:02:40'), Timestamp('2018-04-16 18:41:24'), 37], [20, Timestamp('2018-04-16 18:46:08'), Timestamp('2018-04-16 19:16:16'), 30], [20, Timestamp('2018-04-16 19:21:59'), Timestamp('2018-04-16 19:35:58'), 12], [8, Timestamp('2018-04-16 19:55:56'), Timestamp('2018-04-16 20:37:04'), 52], [8, Timestamp('2018-04-16 20:40:05'), Timestamp('2018-04-16 21:01:10'), 23], [8, Timestamp('2018-04-16 21:07:46'), Timestamp('2018-04-16 21:09:25'), 4], [1, Timestamp('2018-04-16 21:27:09'), Timestamp('2018-04-16 21:40:36'), 20], [1, Timestamp('2018-04-16 21:43:41'), Timestamp('2018-04-16 22:08:53'), 38], [1, Timestamp('2018-04-16 22:12:46'), Timestamp('2018-04-16 22:26:45'), 21], [8, Timestamp('2018-04-16 22:30:52'), Timestamp('2018-04-16 23:46:09'), 88], [8, Timestamp('2018-04-16 23:52:33'), Timestamp('2018-04-17 00:20:32'), 32], [1, Timestamp('2018-04-17 00:22:27'), Timestamp('2018-04-17 00:28:00'), 9], [1, Timestamp('2018-04-17 00:34:14'), Timestamp('2018-04-17 00:35:37'), 6], [1, Timestamp('2018-04-17 00:42:02'), Timestamp('2018-04-17 00:48:24'), 15], [1, Timestamp('2018-04-17 00:55:39'), Timestamp('2018-04-17 02:00:48'), 91], [6, Timestamp('2018-04-17 02:35:01'), Timestamp('2018-04-17 02:46:14'), 27], [6, Timestamp('2018-04-17 02:51:38'), Timestamp('2018-04-17 03:05:53'), 25], [6, Timestamp('2018-04-17 03:12:21'), Timestamp('2018-04-17 03:17:26'), 15], [6, Timestamp('2018-04-17 03:28:07'), Timestamp('2018-04-17 03:38:02'), 23], [6, Timestamp('2018-04-17 03:41:23'), Timestamp('2018-04-17 03:47:11'), 10], [6, Timestamp('2018-04-17 03:51:30'), Timestamp('2018-04-17 03:54:14'), 9], [6, Timestamp('2018-04-17 03:59:13'), Timestamp('2018-04-17 03:59:13'), 1], [6, Timestamp('2018-04-17 04:03:03'), Timestamp('2018-04-17 04:23:15'), 41], [6, Timestamp('2018-04-17 04:28:31'), Timestamp('2018-04-17 04:38:08'), 21], [6, Timestamp('2018-04-17 04:43:15'), Timestamp('2018-04-17 04:43:15'), 1], [6, Timestamp('2018-04-17 04:48:49'), Timestamp('2018-04-17 04:48:49'), 1], [7, Timestamp('2018-04-17 04:49:47'), Timestamp('2018-04-17 05:01:47'), 14], [7, Timestamp('2018-04-17 05:05:49'), Timestamp('2018-04-17 05:07:18'), 5], [7, Timestamp('2018-04-17 05:14:54'), Timestamp('2018-04-17 05:29:47'), 33], [7, Timestamp('2018-04-17 05:32:55'), Timestamp('2018-04-17 05:56:49'), 45], [7, Timestamp('2018-04-17 06:00:08'), Timestamp('2018-04-17 06:00:48'), 2], [7, Timestamp('2018-04-17 06:16:03'), Timestamp('2018-04-17 07:01:49'), 75], [6, Timestamp('2018-04-17 07:03:40'), Timestamp('2018-04-17 07:17:38'), 22], [6, Timestamp('2018-04-17 07:21:04'), Timestamp('2018-04-17 07:38:54'), 34], [6, Timestamp('2018-04-17 07:45:14'), Timestamp('2018-04-17 07:45:55'), 3], [6, Timestamp('2018-04-17 07:50:22'), Timestamp('2018-04-17 07:58:51'), 16], [6, Timestamp('2018-04-17 08:15:17'), Timestamp('2018-04-17 08:17:05'), 6], [6, Timestamp('2018-04-17 08:22:23'), Timestamp('2018-04-17 08:40:03'), 34], [6, Timestamp('2018-04-17 08:43:40'), Timestamp('2018-04-17 08:47:32'), 6], [6, Timestamp('2018-04-17 08:55:43'), Timestamp('2018-04-17 09:06:14'), 29], [7, Timestamp('2018-04-17 09:14:03'), Timestamp('2018-04-17 09:23:37'), 17], [7, Timestamp('2018-04-17 09:27:55'), Timestamp('2018-04-17 09:41:08'), 24], [7, Timestamp('2018-04-17 09:44:26'), Timestamp('2018-04-17 09:54:47'), 22], [7, Timestamp('2018-04-17 09:58:12'), Timestamp('2018-04-17 10:15:53'), 36], [7, Timestamp('2018-04-17 10:21:22'), Timestamp('2018-04-17 10:50:06'), 51], [4, Timestamp('2018-04-17 11:01:29'), Timestamp('2018-04-17 11:20:41'), 30], [4, Timestamp('2018-04-17 11:24:25'), Timestamp('2018-04-17 11:35:55'), 19], [4, Timestamp('2018-04-17 11:43:45'), Timestamp('2018-04-17 11:47:16'), 5], [4, Timestamp('2018-04-17 11:54:23'), Timestamp('2018-04-17 12:09:43'), 18], [4, Timestamp('2018-04-17 12:14:34'), Timestamp('2018-04-17 12:26:08'), 19], [4, Timestamp('2018-04-17 12:30:15'), Timestamp('2018-04-17 13:06:43'), 53], [4, Timestamp('2018-04-17 13:11:53'), Timestamp('2018-04-17 13:15:21'), 6], [4, Timestamp('2018-04-17 13:18:38'), Timestamp('2018-04-17 13:23:33'), 9], [4, Timestamp('2018-04-17 13:27:46'), Timestamp('2018-04-17 13:30:26'), 5], [5, Timestamp('2018-04-17 13:43:38'), Timestamp('2018-04-17 13:54:21'), 12], [5, Timestamp('2018-04-17 13:59:15'), Timestamp('2018-04-17 14:00:38'), 2], [5, Timestamp('2018-04-17 14:04:45'), Timestamp('2018-04-17 14:04:45'), 1], [5, Timestamp('2018-04-17 14:09:37'), Timestamp('2018-04-17 14:49:19'), 59], [5, Timestamp('2018-04-17 14:53:17'), Timestamp('2018-04-17 15:33:38'), 51], [5, Timestamp('2018-04-17 16:53:04'), Timestamp('2018-04-17 17:13:52'), 39], [4, Timestamp('2018-04-17 17:18:48'), Timestamp('2018-04-17 17:41:38'), 31], [4, Timestamp('2018-04-17 17:45:05'), Timestamp('2018-04-17 19:17:22'), 117], [4, Timestamp('2018-04-17 19:20:42'), Timestamp('2018-04-17 19:27:12'), 12], [5, Timestamp('2018-04-17 19:29:46'), Timestamp('2018-04-17 19:45:51'), 19], [5, Timestamp('2018-04-17 19:49:42'), Timestamp('2018-04-17 20:32:41'), 56], [5, Timestamp('2018-04-17 20:36:14'), Timestamp('2018-04-17 20:41:58'), 7], [5, Timestamp('2018-04-17 20:47:18'), Timestamp('2018-04-17 20:54:53'), 15], [5, Timestamp('2018-04-17 21:02:36'), Timestamp('2018-04-17 21:55:31'), 63], [2, Timestamp('2018-04-17 22:06:11'), Timestamp('2018-04-17 22:06:11'), 1], [2, Timestamp('2018-04-17 22:11:48'), Timestamp('2018-04-17 22:11:48'), 1], [2, Timestamp('2018-04-17 22:14:49'), Timestamp('2018-04-17 22:24:52'), 18], [2, Timestamp('2018-04-17 22:30:19'), Timestamp('2018-04-17 22:37:02'), 8], [2, Timestamp('2018-04-17 22:42:19'), Timestamp('2018-04-17 23:03:33'), 30], [2, Timestamp('2018-04-17 23:07:09'), Timestamp('2018-04-17 23:12:51'), 8], [2, Timestamp('2018-04-17 23:18:33'), Timestamp('2018-04-17 23:28:30'), 14], [3, Timestamp('2018-04-17 23:33:49'), Timestamp('2018-04-17 23:41:36'), 12], [3, Timestamp('2018-04-17 23:46:59'), Timestamp('2018-04-18 00:01:57'), 21], [3, Timestamp('2018-04-18 00:05:19'), Timestamp('2018-04-18 00:37:38'), 41], [3, Timestamp('2018-04-18 00:42:31'), Timestamp('2018-04-18 00:47:05'), 6], [6, Timestamp('2018-04-18 01:06:26'), Timestamp('2018-04-18 01:10:06'), 7], [6, Timestamp('2018-04-18 01:14:12'), Timestamp('2018-04-18 01:33:10'), 38], [6, Timestamp('2018-04-18 01:37:59'), Timestamp('2018-04-18 02:17:43'), 78], [6, Timestamp('2018-04-18 02:22:43'), Timestamp('2018-04-18 02:28:44'), 13], [6, Timestamp('2018-04-18 02:34:33'), Timestamp('2018-04-18 02:42:16'), 15], [6, Timestamp('2018-04-18 02:45:35'), Timestamp('2018-04-18 02:55:22'), 22], [7, Timestamp('2018-04-18 03:04:03'), Timestamp('2018-04-18 03:32:05'), 46], [7, Timestamp('2018-04-18 03:39:36'), Timestamp('2018-04-18 04:02:49'), 41], [7, Timestamp('2018-04-18 04:06:14'), Timestamp('2018-04-18 04:15:54'), 16], [7, Timestamp('2018-04-18 04:19:07'), Timestamp('2018-04-18 05:03:30'), 69], [7, Timestamp('2018-04-18 05:10:03'), Timestamp('2018-04-18 05:10:03'), 1], [8, Timestamp('2018-04-18 05:38:26'), Timestamp('2018-04-18 05:43:58'), 8], [8, Timestamp('2018-04-18 05:48:25'), Timestamp('2018-04-18 05:58:03'), 9], [8, Timestamp('2018-04-18 06:03:50'), Timestamp('2018-04-18 06:06:20'), 4], [8, Timestamp('2018-04-18 06:16:49'), Timestamp('2018-04-18 06:22:03'), 7], [8, Timestamp('2018-04-18 06:26:47'), Timestamp('2018-04-18 06:27:38'), 2], [8, Timestamp('2018-04-18 06:31:33'), Timestamp('2018-04-18 06:41:06'), 15], [8, Timestamp('2018-04-18 06:44:42'), Timestamp('2018-04-18 07:37:19'), 59], [8, Timestamp('2018-04-18 07:42:27'), Timestamp('2018-04-18 07:48:21'), 8], [8, Timestamp('2018-04-18 07:53:23'), Timestamp('2018-04-18 08:16:41'), 23], [8, Timestamp('2018-04-18 08:19:46'), Timestamp('2018-04-18 08:20:43'), 3], [1, Timestamp('2018-04-18 08:34:25'), Timestamp('2018-04-18 08:34:25'), 1], [1, Timestamp('2018-04-18 08:37:28'), Timestamp('2018-04-18 09:11:35'), 43], [1, Timestamp('2018-04-18 09:15:39'), Timestamp('2018-04-18 09:22:21'), 13], [1, Timestamp('2018-04-18 09:50:33'), Timestamp('2018-04-18 09:53:33'), 5], [1, Timestamp('2018-04-18 09:57:22'), Timestamp('2018-04-18 10:20:44'), 31], [1, Timestamp('2018-04-18 10:23:46'), Timestamp('2018-04-18 10:34:57'), 21], [1, Timestamp('2018-04-18 10:40:59'), Timestamp('2018-04-18 10:47:49'), 10], [1, Timestamp('2018-04-18 10:52:24'), Timestamp('2018-04-18 10:58:16'), 9], [1, Timestamp('2018-04-18 12:01:20'), Timestamp('2018-04-18 12:02:27'), 4], [4, Timestamp('2018-04-18 12:18:37'), Timestamp('2018-04-18 12:19:16'), 2], [4, Timestamp('2018-04-18 12:30:27'), Timestamp('2018-04-18 12:30:27'), 1], [4, Timestamp('2018-04-18 12:36:17'), Timestamp('2018-04-18 12:49:12'), 18], [4, Timestamp('2018-04-18 12:53:13'), Timestamp('2018-04-18 13:32:39'), 57], [4, Timestamp('2018-04-18 13:35:55'), Timestamp('2018-04-18 14:04:36'), 34], [4, Timestamp('2018-04-18 14:11:28'), Timestamp('2018-04-18 14:14:40'), 6], [4, Timestamp('2018-04-18 14:18:56'), Timestamp('2018-04-18 14:20:07'), 3], [4, Timestamp('2018-04-18 14:24:55'), Timestamp('2018-04-18 14:59:22'), 54], [4, Timestamp('2018-04-18 15:03:30'), Timestamp('2018-04-18 15:19:21'), 22], [4, Timestamp('2018-04-18 15:22:46'), Timestamp('2018-04-18 15:24:31'), 4], [4, Timestamp('2018-04-18 15:29:59'), Timestamp('2018-04-18 15:57:03'), 43], [5, Timestamp('2018-04-18 16:10:01'), Timestamp('2018-04-18 16:39:47'), 43], [5, Timestamp('2018-04-18 16:50:24'), Timestamp('2018-04-18 16:57:47'), 17], [5, Timestamp('2018-04-18 17:01:15'), Timestamp('2018-04-18 17:02:30'), 6], [5, Timestamp('2018-04-18 17:07:53'), Timestamp('2018-04-18 17:16:17'), 16], [5, Timestamp('2018-04-18 17:19:31'), Timestamp('2018-04-18 17:20:11'), 3], [5, Timestamp('2018-04-18 17:26:00'), Timestamp('2018-04-18 17:35:12'), 17], [5, Timestamp('2018-04-18 17:39:09'), Timestamp('2018-04-18 17:42:38'), 6], [5, Timestamp('2018-04-18 17:45:50'), Timestamp('2018-04-18 18:07:31'), 23], [5, Timestamp('2018-04-18 18:11:53'), Timestamp('2018-04-18 18:17:18'), 6], [5, Timestamp('2018-04-18 18:20:46'), Timestamp('2018-04-18 18:32:19'), 12], [5, Timestamp('2018-04-18 18:39:31'), Timestamp('2018-04-18 19:22:06'), 66], [5, Timestamp('2018-04-18 19:25:32'), Timestamp('2018-04-18 19:33:14'), 13], [5, Timestamp('2018-04-18 19:38:12'), Timestamp('2018-04-18 19:47:08'), 16], [10, Timestamp('2018-04-18 20:30:15'), Timestamp('2018-04-18 21:31:01'), 77], [10, Timestamp('2018-04-18 21:35:02'), Timestamp('2018-04-18 22:01:18'), 28], [12, Timestamp('2018-04-18 22:17:09'), Timestamp('2018-04-18 22:20:54'), 4], [12, Timestamp('2018-04-18 22:26:10'), Timestamp('2018-04-18 22:27:33'), 3], [12, Timestamp('2018-04-18 22:33:03'), Timestamp('2018-04-18 22:45:42'), 13], [12, Timestamp('2018-04-18 22:49:06'), Timestamp('2018-04-18 22:49:40'), 2], [12, Timestamp('2018-04-18 22:56:46'), Timestamp('2018-04-18 23:12:48'), 11], [12, Timestamp('2018-04-18 23:16:09'), Timestamp('2018-04-18 23:38:17'), 17], [12, Timestamp('2018-04-18 23:41:30'), Timestamp('2018-04-19 00:10:24'), 22], [12, Timestamp('2018-04-19 00:19:51'), Timestamp('2018-04-19 00:28:59'), 11], [12, Timestamp('2018-04-19 00:35:24'), Timestamp('2018-04-19 00:39:25'), 7], [12, Timestamp('2018-04-19 00:47:15'), Timestamp('2018-04-19 00:59:29'), 11], [12, Timestamp('2018-04-19 01:02:32'), Timestamp('2018-04-19 01:02:32'), 1], [8, Timestamp('2018-04-19 01:16:17'), Timestamp('2018-04-19 01:50:04'), 38], [8, Timestamp('2018-04-19 01:54:16'), Timestamp('2018-04-19 01:54:16'), 1], [8, Timestamp('2018-04-19 01:57:24'), Timestamp('2018-04-19 02:06:06'), 10], [8, Timestamp('2018-04-19 02:09:23'), Timestamp('2018-04-19 02:57:37'), 54], [8, Timestamp('2018-04-19 03:01:49'), Timestamp('2018-04-19 03:04:28'), 4], [8, Timestamp('2018-04-19 03:08:20'), Timestamp('2018-04-19 03:51:25'), 51], [1, Timestamp('2018-04-19 04:12:06'), Timestamp('2018-04-19 04:22:34'), 20], [1, Timestamp('2018-04-19 04:26:24'), Timestamp('2018-04-19 04:40:27'), 24], [1, Timestamp('2018-04-19 04:48:44'), Timestamp('2018-04-19 05:04:34'), 24], [1, Timestamp('2018-04-19 05:08:13'), Timestamp('2018-04-19 05:14:21'), 9], [1, Timestamp('2018-04-19 05:17:46'), Timestamp('2018-04-19 05:22:25'), 8], [1, Timestamp('2018-04-19 05:26:39'), Timestamp('2018-04-19 05:49:15'), 28], [1, Timestamp('2018-04-19 05:52:53'), Timestamp('2018-04-19 06:03:56'), 17], [1, Timestamp('2018-04-19 06:13:50'), Timestamp('2018-04-19 06:29:24'), 26], [8, Timestamp('2018-04-19 06:35:05'), Timestamp('2018-04-19 06:52:44'), 17], [8, Timestamp('2018-04-19 06:58:54'), Timestamp('2018-04-19 07:35:23'), 43], [8, Timestamp('2018-04-19 07:39:41'), Timestamp('2018-04-19 07:41:10'), 5], [8, Timestamp('2018-04-19 07:44:13'), Timestamp('2018-04-19 07:53:14'), 11], [8, Timestamp('2018-04-19 07:58:13'), Timestamp('2018-04-19 08:20:23'), 24], [1, Timestamp('2018-04-19 08:26:22'), Timestamp('2018-04-19 08:34:29'), 12], [1, Timestamp('2018-04-19 08:42:02'), Timestamp('2018-04-19 09:05:43'), 37], [1, Timestamp('2018-04-19 09:08:46'), Timestamp('2018-04-19 09:46:29'), 47], [1, Timestamp('2018-04-19 09:50:44'), Timestamp('2018-04-19 09:54:58'), 4], [26, Timestamp('2018-04-19 12:19:00'), Timestamp('2018-04-19 12:19:26'), 3], [26, Timestamp('2018-04-19 12:24:07'), Timestamp('2018-04-19 12:25:53'), 3], [27, Timestamp('2018-04-19 12:52:34'), Timestamp('2018-04-19 12:52:34'), 1], [27, Timestamp('2018-04-19 12:57:43'), Timestamp('2018-04-19 13:00:14'), 5], [10, Timestamp('2018-04-19 13:30:59'), Timestamp('2018-04-19 13:51:45'), 23], [10, Timestamp('2018-04-19 13:58:55'), Timestamp('2018-04-19 14:21:02'), 25], [10, Timestamp('2018-04-19 14:24:20'), Timestamp('2018-04-19 14:27:04'), 4], [10, Timestamp('2018-04-19 14:32:00'), Timestamp('2018-04-19 14:52:40'), 23], [10, Timestamp('2018-04-19 14:55:50'), Timestamp('2018-04-19 15:25:04'), 32], [12, Timestamp('2018-04-19 15:47:50'), Timestamp('2018-04-19 15:50:33'), 6], [12, Timestamp('2018-04-19 15:59:51'), Timestamp('2018-04-19 16:30:55'), 23], [12, Timestamp('2018-04-19 16:34:53'), Timestamp('2018-04-19 16:40:43'), 6], [12, Timestamp('2018-04-19 16:47:16'), Timestamp('2018-04-19 16:47:16'), 1], [12, Timestamp('2018-04-19 16:58:21'), Timestamp('2018-04-19 17:16:02'), 23], [12, Timestamp('2018-04-19 17:20:27'), Timestamp('2018-04-19 17:20:54'), 2], [12, Timestamp('2018-04-19 17:27:21'), Timestamp('2018-04-19 17:34:53'), 7], [12, Timestamp('2018-04-19 17:38:10'), Timestamp('2018-04-19 18:16:48'), 32], [12, Timestamp('2018-04-19 18:20:21'), Timestamp('2018-04-19 18:28:19'), 7], [4, Timestamp('2018-04-19 19:37:56'), Timestamp('2018-04-19 20:00:39'), 35], [4, Timestamp('2018-04-19 20:03:58'), Timestamp('2018-04-19 20:22:24'), 28], [4, Timestamp('2018-04-19 20:30:07'), Timestamp('2018-04-19 20:30:07'), 1], [4, Timestamp('2018-04-19 20:38:07'), Timestamp('2018-04-19 20:50:11'), 12], [4, Timestamp('2018-04-19 20:55:24'), Timestamp('2018-04-19 21:28:02'), 43], [4, Timestamp('2018-04-19 21:31:48'), Timestamp('2018-04-19 22:07:53'), 48], [5, Timestamp('2018-04-19 22:19:43'), Timestamp('2018-04-19 23:27:37'), 84], [5, Timestamp('2018-04-19 23:30:53'), Timestamp('2018-04-19 23:59:11'), 36], [5, Timestamp('2018-04-20 00:02:20'), Timestamp('2018-04-20 00:24:11'), 30], [5, Timestamp('2018-04-20 00:27:20'), Timestamp('2018-04-20 00:28:05'), 3], [5, Timestamp('2018-04-20 00:31:42'), Timestamp('2018-04-20 00:37:51'), 13], [4, Timestamp('2018-04-20 00:45:17'), Timestamp('2018-04-20 01:03:15'), 24], [4, Timestamp('2018-04-20 01:07:30'), Timestamp('2018-04-20 01:19:11'), 18], [4, Timestamp('2018-04-20 01:22:52'), Timestamp('2018-04-20 01:28:51'), 11], [4, Timestamp('2018-04-20 01:32:35'), Timestamp('2018-04-20 01:51:05'), 27], [4, Timestamp('2018-04-20 01:55:11'), Timestamp('2018-04-20 02:33:32'), 48], [4, Timestamp('2018-04-20 02:39:50'), Timestamp('2018-04-20 02:50:00'), 14], [4, Timestamp('2018-04-20 02:53:08'), Timestamp('2018-04-20 03:20:57'), 33], [5, Timestamp('2018-04-20 03:35:01'), Timestamp('2018-04-20 03:36:11'), 3], [5, Timestamp('2018-04-20 03:39:41'), Timestamp('2018-04-20 03:50:44'), 20], [5, Timestamp('2018-04-20 03:54:17'), Timestamp('2018-04-20 04:03:31'), 14], [5, Timestamp('2018-04-20 04:08:34'), Timestamp('2018-04-20 04:36:02'), 38], [5, Timestamp('2018-04-20 04:40:08'), Timestamp('2018-04-20 05:35:49'), 69], [5, Timestamp('2018-04-20 05:41:12'), Timestamp('2018-04-20 06:03:38'), 31], [5, Timestamp('2018-04-20 06:07:52'), Timestamp('2018-04-20 06:07:52'), 1], [2, Timestamp('2018-04-20 06:13:12'), Timestamp('2018-04-20 06:52:47'), 49], [2, Timestamp('2018-04-20 06:59:09'), Timestamp('2018-04-20 07:21:48'), 34], [2, Timestamp('2018-04-20 07:25:15'), Timestamp('2018-04-20 07:33:28'), 15], [2, Timestamp('2018-04-20 07:37:36'), Timestamp('2018-04-20 07:43:22'), 8], [2, Timestamp('2018-04-20 07:46:37'), Timestamp('2018-04-20 07:52:30'), 7], [2, Timestamp('2018-04-20 07:57:49'), Timestamp('2018-04-20 08:02:27'), 7], [3, Timestamp('2018-04-20 08:09:23'), Timestamp('2018-04-20 08:12:07'), 5], [3, Timestamp('2018-04-20 08:18:49'), Timestamp('2018-04-20 08:33:30'), 20], [3, Timestamp('2018-04-20 11:49:29'), Timestamp('2018-04-20 11:51:02'), 2], [3, Timestamp('2018-04-20 12:03:04'), Timestamp('2018-04-20 13:02:31'), 65], [3, Timestamp('2018-04-20 13:07:07'), Timestamp('2018-04-20 13:27:33'), 26], [3, Timestamp('2018-04-20 13:30:43'), Timestamp('2018-04-20 13:31:08'), 2], [13, Timestamp('2018-04-20 13:37:14'), Timestamp('2018-04-20 14:07:32'), 36], [13, Timestamp('2018-04-20 14:13:49'), Timestamp('2018-04-20 14:13:49'), 1], [13, Timestamp('2018-04-20 14:18:09'), Timestamp('2018-04-20 14:32:40'), 19], [13, Timestamp('2018-04-20 14:35:47'), Timestamp('2018-04-20 14:56:28'), 24], [14, Timestamp('2018-04-20 15:00:40'), Timestamp('2018-04-20 15:01:42'), 3], [14, Timestamp('2018-04-20 15:06:04'), Timestamp('2018-04-20 15:59:00'), 69], [14, Timestamp('2018-04-20 16:04:39'), Timestamp('2018-04-20 16:09:55'), 8], [10, Timestamp('2018-04-20 16:22:27'), Timestamp('2018-04-20 16:34:15'), 19], [10, Timestamp('2018-04-20 16:48:43'), Timestamp('2018-04-20 17:12:11'), 26], [10, Timestamp('2018-04-20 17:22:50'), Timestamp('2018-04-20 17:34:31'), 18], [10, Timestamp('2018-04-20 17:38:51'), Timestamp('2018-04-20 17:51:18'), 17], [12, Timestamp('2018-04-20 18:06:54'), Timestamp('2018-04-20 18:18:31'), 10], [12, Timestamp('2018-04-20 18:25:00'), Timestamp('2018-04-20 18:43:47'), 16], [12, Timestamp('2018-04-20 19:07:30'), Timestamp('2018-04-20 19:36:23'), 24], [12, Timestamp('2018-04-20 19:53:36'), Timestamp('2018-04-20 20:25:21'), 29], [12, Timestamp('2018-04-20 20:30:22'), Timestamp('2018-04-20 20:30:22'), 1], [4, Timestamp('2018-04-20 21:01:25'), Timestamp('2018-04-20 21:06:57'), 10], [4, Timestamp('2018-04-20 21:14:33'), Timestamp('2018-04-20 21:56:20'), 53], [4, Timestamp('2018-04-20 21:59:52'), Timestamp('2018-04-20 22:07:21'), 11], [4, Timestamp('2018-04-20 22:13:04'), Timestamp('2018-04-20 22:28:13'), 24], [4, Timestamp('2018-04-20 22:33:56'), Timestamp('2018-04-20 22:33:56'), 1], [4, Timestamp('2018-04-20 22:38:30'), Timestamp('2018-04-20 22:42:54'), 10], [4, Timestamp('2018-04-20 22:47:09'), Timestamp('2018-04-20 23:25:27'), 55], [5, Timestamp('2018-04-20 23:27:18'), Timestamp('2018-04-20 23:34:13'), 11], [5, Timestamp('2018-04-20 23:37:44'), Timestamp('2018-04-21 00:05:36'), 39], [5, Timestamp('2018-04-21 00:09:06'), Timestamp('2018-04-21 00:25:07'), 22], [5, Timestamp('2018-04-21 00:29:15'), Timestamp('2018-04-21 00:53:41'), 34], [5, Timestamp('2018-04-21 01:03:03'), Timestamp('2018-04-21 01:08:27'), 11], [5, Timestamp('2018-04-21 01:13:46'), Timestamp('2018-04-21 01:23:53'), 13], [5, Timestamp('2018-04-21 01:27:29'), Timestamp('2018-04-21 01:49:37'), 34], [4, Timestamp('2018-04-21 01:54:27'), Timestamp('2018-04-21 01:58:11'), 6], [4, Timestamp('2018-04-21 02:02:14'), Timestamp('2018-04-21 02:02:14'), 1], [4, Timestamp('2018-04-21 02:06:28'), Timestamp('2018-04-21 04:02:34'), 146], [4, Timestamp('2018-04-21 04:05:42'), Timestamp('2018-04-21 04:06:54'), 3], [4, Timestamp('2018-04-21 04:13:48'), Timestamp('2018-04-21 04:24:28'), 19], [5, Timestamp('2018-04-21 04:32:49'), Timestamp('2018-04-21 04:33:30'), 2], [5, Timestamp('2018-04-21 04:42:54'), Timestamp('2018-04-21 04:51:02'), 14], [5, Timestamp('2018-04-21 04:56:46'), Timestamp('2018-04-21 05:02:32'), 10], [5, Timestamp('2018-04-21 05:05:51'), Timestamp('2018-04-21 05:05:51'), 1], [5, Timestamp('2018-04-21 05:09:11'), Timestamp('2018-04-21 05:29:38'), 34], [5, Timestamp('2018-04-21 05:32:40'), Timestamp('2018-04-21 05:44:48'), 19], [5, Timestamp('2018-04-21 05:48:24'), Timestamp('2018-04-21 06:11:53'), 31], [5, Timestamp('2018-04-21 06:16:21'), Timestamp('2018-04-21 07:06:02'), 64], [24, Timestamp('2018-04-21 07:31:18'), Timestamp('2018-04-21 08:11:49'), 78], [24, Timestamp('2018-04-21 08:15:38'), Timestamp('2018-04-21 08:55:31'), 69], [24, Timestamp('2018-04-21 09:12:12'), Timestamp('2018-04-21 09:15:30'), 13], [25, Timestamp('2018-04-21 09:28:30'), Timestamp('2018-04-21 09:56:11'), 48], [25, Timestamp('2018-04-21 10:00:51'), Timestamp('2018-04-21 10:01:35'), 2], [25, Timestamp('2018-04-21 10:04:42'), Timestamp('2018-04-21 10:55:15'), 93], [25, Timestamp('2018-04-21 10:59:19'), Timestamp('2018-04-21 11:05:35'), 17], [10, Timestamp('2018-04-21 11:29:40'), Timestamp('2018-04-21 11:50:57'), 28], [10, Timestamp('2018-04-21 11:55:32'), Timestamp('2018-04-21 12:16:49'), 26], [10, Timestamp('2018-04-21 12:20:16'), Timestamp('2018-04-21 12:36:26'), 20], [10, Timestamp('2018-04-21 12:39:46'), Timestamp('2018-04-21 12:48:56'), 14], [10, Timestamp('2018-04-21 12:52:29'), Timestamp('2018-04-21 13:15:12'), 30], [10, Timestamp('2018-04-21 13:23:33'), Timestamp('2018-04-21 13:51:10'), 42], [12, Timestamp('2018-04-21 14:00:50'), Timestamp('2018-04-21 14:10:08'), 9], [12, Timestamp('2018-04-21 14:14:19'), Timestamp('2018-04-21 14:50:01'), 27], [12, Timestamp('2018-04-21 14:57:26'), Timestamp('2018-04-21 14:59:15'), 3], [12, Timestamp('2018-04-21 15:03:10'), Timestamp('2018-04-21 15:04:16'), 3], [12, Timestamp('2018-04-21 15:07:17'), Timestamp('2018-04-21 15:13:28'), 8], [12, Timestamp('2018-04-21 15:18:28'), Timestamp('2018-04-21 15:18:28'), 1], [12, Timestamp('2018-04-21 15:24:08'), Timestamp('2018-04-21 15:45:30'), 18], [12, Timestamp('2018-04-21 15:53:04'), Timestamp('2018-04-21 16:00:39'), 7], [12, Timestamp('2018-04-21 16:05:02'), Timestamp('2018-04-21 16:07:20'), 4], [12, Timestamp('2018-04-21 16:10:50'), Timestamp('2018-04-21 16:21:59'), 11], [12, Timestamp('2018-04-21 16:25:14'), Timestamp('2018-04-21 16:53:25'), 22], [12, Timestamp('2018-04-21 16:57:37'), Timestamp('2018-04-21 17:10:22'), 10], [12, Timestamp('2018-04-21 17:13:30'), Timestamp('2018-04-21 17:19:33'), 5], [12, Timestamp('2018-04-21 17:23:48'), Timestamp('2018-04-21 17:24:21'), 2], [12, Timestamp('2018-04-21 17:31:11'), Timestamp('2018-04-21 17:33:15'), 4], [12, Timestamp('2018-04-21 17:40:26'), Timestamp('2018-04-21 17:51:27'), 11], [12, Timestamp('2018-04-21 17:54:56'), Timestamp('2018-04-21 18:12:49'), 15], [4, Timestamp('2018-04-21 18:21:17'), Timestamp('2018-04-21 18:31:35'), 18], [4, Timestamp('2018-04-21 18:35:58'), Timestamp('2018-04-21 18:56:05'), 32], [4, Timestamp('2018-04-21 19:00:33'), Timestamp('2018-04-21 19:06:55'), 10], [4, Timestamp('2018-04-21 19:14:24'), Timestamp('2018-04-21 19:19:22'), 9], [4, Timestamp('2018-04-21 19:23:36'), Timestamp('2018-04-21 19:45:57'), 36], [4, Timestamp('2018-04-21 19:49:37'), Timestamp('2018-04-21 19:57:26'), 10], [4, Timestamp('2018-04-21 20:06:33'), Timestamp('2018-04-21 20:18:59'), 17], [5, Timestamp('2018-04-21 20:23:08'), Timestamp('2018-04-21 20:59:11'), 49], [5, Timestamp('2018-04-21 21:02:37'), Timestamp('2018-04-21 21:08:47'), 11], [5, Timestamp('2018-04-21 21:13:07'), Timestamp('2018-04-21 21:28:55'), 24], [5, Timestamp('2018-04-21 21:32:35'), Timestamp('2018-04-21 22:09:32'), 48], [4, Timestamp('2018-04-21 22:24:17'), Timestamp('2018-04-21 23:05:28'), 55], [4, Timestamp('2018-04-21 23:20:48'), Timestamp('2018-04-21 23:28:02'), 8], [4, Timestamp('2018-04-21 23:33:09'), Timestamp('2018-04-21 23:53:16'), 30], [4, Timestamp('2018-04-21 23:58:27'), Timestamp('2018-04-22 00:33:51'), 48], [4, Timestamp('2018-04-22 00:38:46'), Timestamp('2018-04-22 00:43:05'), 6], [4, Timestamp('2018-04-22 00:47:00'), Timestamp('2018-04-22 01:00:42'), 20], [4, Timestamp('2018-04-22 01:06:29'), Timestamp('2018-04-22 01:12:56'), 12], [5, Timestamp('2018-04-22 01:14:48'), Timestamp('2018-04-22 01:22:22'), 12], [5, Timestamp('2018-04-22 01:25:31'), Timestamp('2018-04-22 02:19:47'), 70], [5, Timestamp('2018-04-22 02:25:18'), Timestamp('2018-04-22 02:33:04'), 13], [5, Timestamp('2018-04-22 02:37:54'), Timestamp('2018-04-22 02:49:46'), 18], [5, Timestamp('2018-04-22 02:54:07'), Timestamp('2018-04-22 03:29:17'), 43], [5, Timestamp('2018-04-22 03:32:18'), Timestamp('2018-04-22 03:32:18'), 1], [5, Timestamp('2018-04-22 03:36:19'), Timestamp('2018-04-22 03:50:31'), 22], [2, Timestamp('2018-04-22 03:54:33'), Timestamp('2018-04-22 04:10:41'), 20], [2, Timestamp('2018-04-22 04:19:49'), Timestamp('2018-04-22 04:44:59'), 32], [2, Timestamp('2018-04-22 04:50:50'), Timestamp('2018-04-22 04:58:48'), 11], [2, Timestamp('2018-04-22 05:01:57'), Timestamp('2018-04-22 05:15:27'), 20], [2, Timestamp('2018-04-22 05:19:43'), Timestamp('2018-04-22 05:41:59'), 30], [3, Timestamp('2018-04-22 05:47:07'), Timestamp('2018-04-22 06:12:11'), 32], [3, Timestamp('2018-04-22 06:16:18'), Timestamp('2018-04-22 07:17:41'), 78], [3, Timestamp('2018-04-22 07:20:55'), Timestamp('2018-04-22 07:22:23'), 3], [4, Timestamp('2018-04-22 07:28:11'), Timestamp('2018-04-22 07:43:40'), 20], [4, Timestamp('2018-04-22 07:46:51'), Timestamp('2018-04-22 08:32:22'), 66], [4, Timestamp('2018-04-22 08:37:10'), Timestamp('2018-04-22 08:38:08'), 3], [4, Timestamp('2018-04-22 08:53:00'), Timestamp('2018-04-22 09:03:26'), 18], [4, Timestamp('2018-04-22 09:08:04'), Timestamp('2018-04-22 09:23:46'), 27], [4, Timestamp('2018-04-22 09:27:12'), Timestamp('2018-04-22 09:27:49'), 2], [4, Timestamp('2018-04-22 09:32:17'), Timestamp('2018-04-22 09:52:15'), 31], [4, Timestamp('2018-04-22 09:55:57'), Timestamp('2018-04-22 10:31:02'), 52], [4, Timestamp('2018-04-22 10:34:58'), Timestamp('2018-04-22 10:44:25'), 17], [4, Timestamp('2018-04-22 10:47:32'), Timestamp('2018-04-22 10:55:27'), 14], [5, Timestamp('2018-04-22 10:57:19'), Timestamp('2018-04-22 11:23:03'), 33], [5, Timestamp('2018-04-22 11:26:55'), Timestamp('2018-04-22 11:41:52'), 22], [5, Timestamp('2018-04-22 11:46:59'), Timestamp('2018-04-22 11:52:02'), 9], [5, Timestamp('2018-04-22 11:57:37'), Timestamp('2018-04-22 13:23:46'), 112], [5, Timestamp('2018-04-22 13:27:22'), Timestamp('2018-04-22 14:14:40'), 59], [5, Timestamp('2018-04-22 14:18:02'), Timestamp('2018-04-22 14:23:35'), 9], [5, Timestamp('2018-04-22 14:27:11'), Timestamp('2018-04-22 14:32:20'), 6], [9, Timestamp('2018-04-22 14:36:45'), Timestamp('2018-04-22 15:19:36'), 57], [9, Timestamp('2018-04-22 15:23:43'), Timestamp('2018-04-22 15:23:43'), 1], [9, Timestamp('2018-04-22 15:26:46'), Timestamp('2018-04-22 15:37:22'), 18], [9, Timestamp('2018-04-22 15:42:42'), Timestamp('2018-04-22 15:44:12'), 4], [13, Timestamp('2018-04-22 15:50:47'), Timestamp('2018-04-22 16:37:49'), 65], [13, Timestamp('2018-04-22 16:42:41'), Timestamp('2018-04-22 16:49:08'), 9], [13, Timestamp('2018-04-22 16:52:34'), Timestamp('2018-04-22 16:55:56'), 6], [11, Timestamp('2018-04-22 17:00:16'), Timestamp('2018-04-22 17:26:55'), 34], [11, Timestamp('2018-04-22 17:31:23'), Timestamp('2018-04-22 18:03:44'), 46], [14, Timestamp('2018-04-22 18:37:25'), Timestamp('2018-04-22 18:39:54'), 4], [14, Timestamp('2018-04-22 18:44:54'), Timestamp('2018-04-22 18:47:20'), 7], [14, Timestamp('2018-04-22 18:51:20'), Timestamp('2018-04-22 18:54:12'), 4], [14, Timestamp('2018-04-22 18:58:42'), Timestamp('2018-04-22 19:02:40'), 7], [14, Timestamp('2018-04-22 19:06:22'), Timestamp('2018-04-22 19:42:38'), 47], [14, Timestamp('2018-04-22 19:45:40'), Timestamp('2018-04-22 19:51:08'), 11], [24, Timestamp('2018-04-22 20:09:15'), Timestamp('2018-04-22 20:09:15'), 1], [24, Timestamp('2018-04-22 20:21:08'), Timestamp('2018-04-22 20:23:44'), 6], [24, Timestamp('2018-04-22 20:27:40'), Timestamp('2018-04-22 20:43:23'), 32], [24, Timestamp('2018-04-22 20:48:03'), Timestamp('2018-04-22 21:09:01'), 40], [24, Timestamp('2018-04-22 21:17:10'), Timestamp('2018-04-22 22:04:20'), 92], [24, Timestamp('2018-04-22 22:08:00'), Timestamp('2018-04-22 22:20:36'), 21], [24, Timestamp('2018-04-22 22:24:18'), Timestamp('2018-04-22 22:31:04'), 13], [24, Timestamp('2018-04-22 22:39:10'), Timestamp('2018-04-22 23:03:09'), 47], [24, Timestamp('2018-04-22 23:11:04'), Timestamp('2018-04-22 23:41:36'), 61], [24, Timestamp('2018-04-22 23:47:07'), Timestamp('2018-04-22 23:49:31'), 7], [25, Timestamp('2018-04-22 23:59:33'), Timestamp('2018-04-23 00:06:01'), 12], [25, Timestamp('2018-04-23 00:11:42'), Timestamp('2018-04-23 01:07:49'), 101], [25, Timestamp('2018-04-23 01:11:10'), Timestamp('2018-04-23 01:26:53'), 26], [25, Timestamp('2018-04-23 01:31:29'), Timestamp('2018-04-23 01:34:27'), 11], [25, Timestamp('2018-04-23 01:42:27'), Timestamp('2018-04-23 01:51:36'), 16], [25, Timestamp('2018-04-23 01:55:54'), Timestamp('2018-04-23 03:18:43'), 140], [25, Timestamp('2018-04-23 03:27:38'), Timestamp('2018-04-23 03:27:38'), 1], [25, Timestamp('2018-04-23 03:33:06'), Timestamp('2018-04-23 03:46:24'), 13], [4, Timestamp('2018-04-23 03:52:39'), Timestamp('2018-04-23 04:08:11'), 26], [4, Timestamp('2018-04-23 04:14:25'), Timestamp('2018-04-23 04:20:06'), 11], [4, Timestamp('2018-04-23 04:28:40'), Timestamp('2018-04-23 04:35:09'), 12], [4, Timestamp('2018-04-23 04:38:20'), Timestamp('2018-04-23 04:46:03'), 14], [4, Timestamp('2018-04-23 04:49:43'), Timestamp('2018-04-23 05:33:42'), 63], [4, Timestamp('2018-04-23 05:38:32'), Timestamp('2018-04-23 05:53:37'), 20], [4, Timestamp('2018-04-23 05:56:41'), Timestamp('2018-04-23 05:57:18'), 2], [4, Timestamp('2018-04-23 06:01:06'), Timestamp('2018-04-23 06:02:51'), 4], [4, Timestamp('2018-04-23 06:10:17'), Timestamp('2018-04-23 06:16:49'), 10], [4, Timestamp('2018-04-23 06:21:43'), Timestamp('2018-04-23 06:22:46'), 3], [4, Timestamp('2018-04-23 06:26:19'), Timestamp('2018-04-23 06:47:42'), 35], [5, Timestamp('2018-04-23 07:00:15'), Timestamp('2018-04-23 07:00:54'), 3], [5, Timestamp('2018-04-23 07:04:51'), Timestamp('2018-04-23 07:24:16'), 25], [5, Timestamp('2018-04-23 07:28:22'), Timestamp('2018-04-23 07:29:28'), 3], [5, Timestamp('2018-04-23 07:32:36'), Timestamp('2018-04-23 07:58:42'), 32], [5, Timestamp('2018-04-23 08:01:47'), Timestamp('2018-04-23 08:13:37'), 17], [5, Timestamp('2018-04-23 08:17:00'), Timestamp('2018-04-23 08:31:24'), 21], [5, Timestamp('2018-04-23 08:44:37'), Timestamp('2018-04-23 08:54:52'), 18], [5, Timestamp('2018-04-23 08:58:18'), Timestamp('2018-04-23 09:03:57'), 9], [5, Timestamp('2018-04-23 09:08:28'), Timestamp('2018-04-23 09:23:45'), 19], [5, Timestamp('2018-04-23 09:28:44'), Timestamp('2018-04-23 09:32:29'), 11], [5, Timestamp('2018-04-23 09:36:03'), Timestamp('2018-04-23 10:10:24'), 42], [6, Timestamp('2018-04-23 10:27:35'), Timestamp('2018-04-23 10:27:35'), 1], [6, Timestamp('2018-04-23 10:37:27'), Timestamp('2018-04-23 11:15:52'), 68], [6, Timestamp('2018-04-23 11:27:44'), Timestamp('2018-04-23 11:30:20'), 4], [6, Timestamp('2018-04-23 11:33:51'), Timestamp('2018-04-23 11:34:41'), 3], [6, Timestamp('2018-04-23 11:39:15'), Timestamp('2018-04-23 11:52:08'), 24], [6, Timestamp('2018-04-23 11:55:57'), Timestamp('2018-04-23 12:03:12'), 14], [6, Timestamp('2018-04-23 12:06:34'), Timestamp('2018-04-23 12:06:59'), 2], [6, Timestamp('2018-04-23 12:10:39'), Timestamp('2018-04-23 12:14:03'), 5], [6, Timestamp('2018-04-23 12:21:28'), Timestamp('2018-04-23 12:21:28'), 1], [28, Timestamp('2018-04-23 13:52:40'), Timestamp('2018-04-23 14:00:14'), 13], [28, Timestamp('2018-04-23 14:09:51'), Timestamp('2018-04-23 14:09:52'), 2], [29, Timestamp('2018-04-23 15:57:57'), Timestamp('2018-04-23 15:59:18'), 4], [29, Timestamp('2018-04-23 16:02:41'), Timestamp('2018-04-23 16:07:58'), 11], [6, Timestamp('2018-04-23 16:23:40'), Timestamp('2018-04-23 16:25:08'), 2], [6, Timestamp('2018-04-23 16:32:34'), Timestamp('2018-04-23 16:39:22'), 17], [6, Timestamp('2018-04-23 16:42:43'), Timestamp('2018-04-23 16:48:27'), 12], [6, Timestamp('2018-04-23 16:53:25'), Timestamp('2018-04-23 16:58:14'), 10], [7, Timestamp('2018-04-23 17:01:37'), Timestamp('2018-04-23 17:08:11'), 10], [7, Timestamp('2018-04-23 17:11:47'), Timestamp('2018-04-23 17:21:25'), 21], [7, Timestamp('2018-04-23 17:27:58'), Timestamp('2018-04-23 17:35:17'), 14], [7, Timestamp('2018-04-23 17:43:17'), Timestamp('2018-04-23 17:55:35'), 26], [7, Timestamp('2018-04-23 18:00:33'), Timestamp('2018-04-23 18:16:11'), 34], [7, Timestamp('2018-04-23 18:21:19'), Timestamp('2018-04-23 18:22:48'), 4], [7, Timestamp('2018-04-23 18:27:04'), Timestamp('2018-04-23 18:54:02'), 53], [10, Timestamp('2018-04-23 19:14:05'), Timestamp('2018-04-23 19:30:53'), 22], [10, Timestamp('2018-04-23 19:34:12'), Timestamp('2018-04-23 20:17:42'), 52], [10, Timestamp('2018-04-23 20:21:23'), Timestamp('2018-04-23 20:47:16'), 31], [12, Timestamp('2018-04-23 21:05:49'), Timestamp('2018-04-23 21:14:30'), 8], [12, Timestamp('2018-04-23 21:20:41'), Timestamp('2018-04-23 21:26:26'), 4], [12, Timestamp('2018-04-23 21:29:50'), Timestamp('2018-04-23 21:36:56'), 5], [12, Timestamp('2018-04-23 21:41:55'), Timestamp('2018-04-23 21:47:15'), 7], [12, Timestamp('2018-04-23 21:54:03'), Timestamp('2018-04-23 21:54:03'), 1], [12, Timestamp('2018-04-23 22:03:58'), Timestamp('2018-04-23 22:18:09'), 16], [12, Timestamp('2018-04-23 22:21:11'), Timestamp('2018-04-23 22:40:05'), 13], [12, Timestamp('2018-04-23 22:47:57'), Timestamp('2018-04-23 22:58:20'), 12], [12, Timestamp('2018-04-23 23:05:19'), Timestamp('2018-04-23 23:12:01'), 5], [12, Timestamp('2018-04-23 23:15:20'), Timestamp('2018-04-23 23:30:39'), 12], [12, Timestamp('2018-04-23 23:33:42'), Timestamp('2018-04-23 23:36:22'), 4], [12, Timestamp('2018-04-23 23:39:57'), Timestamp('2018-04-23 23:45:35'), 5], [12, Timestamp('2018-04-23 23:55:24'), Timestamp('2018-04-24 00:10:39'), 13], [10, Timestamp('2018-04-24 00:13:17'), Timestamp('2018-04-24 00:48:59'), 38], [10, Timestamp('2018-04-24 00:52:24'), Timestamp('2018-04-24 02:00:50'), 79], [12, Timestamp('2018-04-24 02:08:21'), Timestamp('2018-04-24 02:38:09'), 23], [12, Timestamp('2018-04-24 02:42:09'), Timestamp('2018-04-24 03:10:27'), 24], [12, Timestamp('2018-04-24 03:19:50'), Timestamp('2018-04-24 03:29:09'), 9], [12, Timestamp('2018-04-24 03:32:56'), Timestamp('2018-04-24 03:32:56'), 1], [12, Timestamp('2018-04-24 03:37:00'), Timestamp('2018-04-24 03:53:10'), 13], [12, Timestamp('2018-04-24 03:59:23'), Timestamp('2018-04-24 04:02:03'), 3], [12, Timestamp('2018-04-24 04:07:36'), Timestamp('2018-04-24 04:11:20'), 4], [12, Timestamp('2018-04-24 04:16:03'), Timestamp('2018-04-24 04:23:13'), 9], [12, Timestamp('2018-04-24 04:29:12'), Timestamp('2018-04-24 04:34:44'), 7], [12, Timestamp('2018-04-24 04:42:28'), Timestamp('2018-04-24 04:54:03'), 14], [12, Timestamp('2018-04-24 04:57:08'), Timestamp('2018-04-24 05:08:30'), 10], [20, Timestamp('2018-04-24 06:23:52'), Timestamp('2018-04-24 06:45:59'), 17], [20, Timestamp('2018-04-24 06:49:31'), Timestamp('2018-04-24 07:18:13'), 28], [20, Timestamp('2018-04-24 07:22:53'), Timestamp('2018-04-24 07:40:16'), 17], [20, Timestamp('2018-04-24 07:43:38'), Timestamp('2018-04-24 07:48:49'), 6], [20, Timestamp('2018-04-24 07:52:45'), Timestamp('2018-04-24 08:00:09'), 7], [20, Timestamp('2018-04-24 08:03:29'), Timestamp('2018-04-24 08:23:46'), 19], [20, Timestamp('2018-04-24 08:29:30'), Timestamp('2018-04-24 08:36:47'), 8], [20, Timestamp('2018-04-24 08:41:03'), Timestamp('2018-04-24 09:45:39'), 63], [20, Timestamp('2018-04-24 09:53:15'), Timestamp('2018-04-24 09:55:11'), 3], [20, Timestamp('2018-04-24 09:58:41'), Timestamp('2018-04-24 09:58:41'), 1], [20, Timestamp('2018-04-24 10:03:01'), Timestamp('2018-04-24 10:03:01'), 1], [20, Timestamp('2018-04-24 10:06:25'), Timestamp('2018-04-24 10:07:09'), 2], [20, Timestamp('2018-04-24 10:10:23'), Timestamp('2018-04-24 10:12:28'), 3], [20, Timestamp('2018-04-24 10:16:37'), Timestamp('2018-04-24 10:50:04'), 31], [20, Timestamp('2018-04-24 10:56:19'), Timestamp('2018-04-24 11:01:45'), 5], [20, Timestamp('2018-04-24 11:06:23'), Timestamp('2018-04-24 11:25:27'), 21], [20, Timestamp('2018-04-24 11:34:46'), Timestamp('2018-04-24 11:49:44'), 16], [20, Timestamp('2018-04-24 11:59:24'), Timestamp('2018-04-24 12:10:23'), 11], [20, Timestamp('2018-04-24 12:13:29'), Timestamp('2018-04-24 12:21:17'), 9], [20, Timestamp('2018-04-24 12:26:44'), Timestamp('2018-04-24 12:49:56'), 21], [20, Timestamp('2018-04-24 13:02:01'), Timestamp('2018-04-24 13:05:54'), 5], [20, Timestamp('2018-04-24 13:09:08'), Timestamp('2018-04-24 13:19:07'), 11], [20, Timestamp('2018-04-24 13:29:09'), Timestamp('2018-04-24 13:36:43'), 7], [20, Timestamp('2018-04-24 13:41:08'), Timestamp('2018-04-24 13:57:46'), 15], [8, Timestamp('2018-04-24 14:20:38'), Timestamp('2018-04-24 15:28:23'), 74], [1, Timestamp('2018-04-24 16:27:51'), Timestamp('2018-04-24 16:27:51'), 1], [1, Timestamp('2018-04-24 16:32:30'), Timestamp('2018-04-24 16:34:55'), 6], [1, Timestamp('2018-04-24 16:39:51'), Timestamp('2018-04-24 16:45:14'), 14], [1, Timestamp('2018-04-24 16:48:22'), Timestamp('2018-04-24 16:56:00'), 12], [1, Timestamp('2018-04-24 17:02:06'), Timestamp('2018-04-24 17:07:27'), 12], [1, Timestamp('2018-04-24 17:13:18'), Timestamp('2018-04-24 17:24:33'), 17], [1, Timestamp('2018-04-24 17:27:50'), Timestamp('2018-04-24 17:34:41'), 12], [22, Timestamp('2018-04-24 18:11:50'), Timestamp('2018-04-24 18:17:10'), 5], [22, Timestamp('2018-04-24 18:25:27'), Timestamp('2018-04-24 18:25:27'), 1], [22, Timestamp('2018-04-24 18:34:32'), Timestamp('2018-04-24 18:53:35'), 22], [22, Timestamp('2018-04-24 18:58:26'), Timestamp('2018-04-24 19:13:02'), 20], [22, Timestamp('2018-04-24 19:25:10'), Timestamp('2018-04-24 19:33:30'), 16], [22, Timestamp('2018-04-24 19:48:28'), Timestamp('2018-04-24 20:26:33'), 53], [22, Timestamp('2018-04-24 20:32:09'), Timestamp('2018-04-24 20:50:09'), 25], [22, Timestamp('2018-04-24 20:54:30'), Timestamp('2018-04-24 21:11:25'), 20], [23, Timestamp('2018-04-24 21:15:05'), Timestamp('2018-04-24 21:29:25'), 21], [23, Timestamp('2018-04-24 21:33:07'), Timestamp('2018-04-24 21:33:07'), 1], [23, Timestamp('2018-04-24 21:39:07'), Timestamp('2018-04-24 21:56:59'), 26], [23, Timestamp('2018-04-24 22:00:09'), Timestamp('2018-04-24 22:07:12'), 11], [23, Timestamp('2018-04-24 22:12:14'), Timestamp('2018-04-24 22:25:14'), 20], [23, Timestamp('2018-04-24 22:29:10'), Timestamp('2018-04-24 23:13:22'), 68], [23, Timestamp('2018-04-24 23:17:12'), Timestamp('2018-04-24 23:26:53'), 15], [28, Timestamp('2018-04-24 23:53:45'), Timestamp('2018-04-24 23:58:54'), 8], [28, Timestamp('2018-04-25 00:02:27'), Timestamp('2018-04-25 00:03:51'), 6], [28, Timestamp('2018-04-25 00:09:01'), Timestamp('2018-04-25 00:13:21'), 16], [28, Timestamp('2018-04-25 00:18:29'), Timestamp('2018-04-25 00:32:52'), 36], [28, Timestamp('2018-04-25 00:37:29'), Timestamp('2018-04-25 00:51:44'), 34], [28, Timestamp('2018-04-25 01:01:59'), Timestamp('2018-04-25 01:14:02'), 29], [28, Timestamp('2018-04-25 01:20:36'), Timestamp('2018-04-25 01:24:21'), 15], [28, Timestamp('2018-04-25 01:29:21'), Timestamp('2018-04-25 01:29:21'), 1], [29, Timestamp('2018-04-25 01:39:38'), Timestamp('2018-04-25 03:12:45'), 96], [29, Timestamp('2018-04-25 03:17:36'), Timestamp('2018-04-25 03:28:21'), 12], [29, Timestamp('2018-04-25 03:32:08'), Timestamp('2018-04-25 03:56:41'), 23], [29, Timestamp('2018-04-25 03:59:48'), Timestamp('2018-04-25 04:09:33'), 11], [2, Timestamp('2018-04-25 04:22:13'), Timestamp('2018-04-25 04:27:40'), 8], [2, Timestamp('2018-04-25 04:31:21'), Timestamp('2018-04-25 05:28:27'), 75], [2, Timestamp('2018-04-25 05:44:51'), Timestamp('2018-04-25 06:05:09'), 30], [2, Timestamp('2018-04-25 06:08:31'), Timestamp('2018-04-25 06:12:38'), 6], [2, Timestamp('2018-04-25 06:20:34'), Timestamp('2018-04-25 06:25:37'), 6], [3, Timestamp('2018-04-25 06:33:03'), Timestamp('2018-04-25 06:47:08'), 21], [3, Timestamp('2018-04-25 06:50:27'), Timestamp('2018-04-25 07:35:20'), 61], [3, Timestamp('2018-04-25 07:39:16'), Timestamp('2018-04-25 08:10:12'), 42], [9, Timestamp('2018-04-25 08:16:58'), Timestamp('2018-04-25 08:17:48'), 2], [9, Timestamp('2018-04-25 14:17:50'), Timestamp('2018-04-25 14:17:50'), 2], [9, Timestamp('2018-04-25 14:38:17'), Timestamp('2018-04-25 15:07:45'), 41], [4, Timestamp('2018-04-25 15:13:18'), Timestamp('2018-04-25 15:44:10'), 40], [4, Timestamp('2018-04-25 15:48:28'), Timestamp('2018-04-25 15:53:52'), 6], [4, Timestamp('2018-04-25 15:58:01'), Timestamp('2018-04-25 15:58:01'), 1], [4, Timestamp('2018-04-25 16:03:04'), Timestamp('2018-04-25 16:03:04'), 1], [4, Timestamp('2018-04-25 16:09:47'), Timestamp('2018-04-25 16:25:08'), 27], [4, Timestamp('2018-04-25 16:28:18'), Timestamp('2018-04-25 16:54:44'), 38], [4, Timestamp('2018-04-25 16:57:57'), Timestamp('2018-04-25 17:17:00'), 29], [4, Timestamp('2018-04-25 17:22:14'), Timestamp('2018-04-25 17:28:06'), 11], [5, Timestamp('2018-04-25 17:32:29'), Timestamp('2018-04-25 17:36:58'), 8], [5, Timestamp('2018-04-25 17:41:32'), Timestamp('2018-04-25 18:37:13'), 71], [5, Timestamp('2018-04-25 18:43:29'), Timestamp('2018-04-25 19:09:31'), 39], [5, Timestamp('2018-04-25 19:13:08'), Timestamp('2018-04-25 19:24:40'), 19], [5, Timestamp('2018-04-25 19:28:49'), Timestamp('2018-04-25 19:38:17'), 16], [4, Timestamp('2018-04-25 19:45:40'), Timestamp('2018-04-25 19:54:32'), 13], [4, Timestamp('2018-04-25 19:58:34'), Timestamp('2018-04-25 20:20:26'), 34], [4, Timestamp('2018-04-25 20:23:30'), Timestamp('2018-04-25 20:27:41'), 8], [4, Timestamp('2018-04-25 20:30:53'), Timestamp('2018-04-25 21:01:22'), 45], [5, Timestamp('2018-04-25 21:04:32'), Timestamp('2018-04-25 21:39:45'), 43], [5, Timestamp('2018-04-25 21:45:42'), Timestamp('2018-04-25 21:58:01'), 16], [5, Timestamp('2018-04-25 22:05:04'), Timestamp('2018-04-25 22:40:04'), 41], [8, Timestamp('2018-04-25 23:02:30'), Timestamp('2018-04-25 23:47:53'), 54], [8, Timestamp('2018-04-25 23:51:29'), Timestamp('2018-04-26 00:40:41'), 60], [8, Timestamp('2018-04-26 00:44:49'), Timestamp('2018-04-26 00:44:49'), 1], [8, Timestamp('2018-04-26 00:52:11'), Timestamp('2018-04-26 00:52:11'), 1], [8, Timestamp('2018-04-26 00:59:46'), Timestamp('2018-04-26 01:04:46'), 7], [1, Timestamp('2018-04-26 01:12:16'), Timestamp('2018-04-26 01:36:31'), 38], [1, Timestamp('2018-04-26 01:40:21'), Timestamp('2018-04-26 02:12:52'), 49], [1, Timestamp('2018-04-26 02:19:35'), Timestamp('2018-04-26 02:43:43'), 36], [16, Timestamp('2018-04-26 02:50:08'), Timestamp('2018-04-26 03:01:56'), 14], [16, Timestamp('2018-04-26 03:11:59'), Timestamp('2018-04-26 03:17:00'), 7], [16, Timestamp('2018-04-26 03:22:21'), Timestamp('2018-04-26 04:14:12'), 59], [18, Timestamp('2018-04-26 04:17:12'), Timestamp('2018-04-26 04:31:50'), 17], [18, Timestamp('2018-04-26 04:36:55'), Timestamp('2018-04-26 04:49:01'), 22], [18, Timestamp('2018-04-26 04:53:48'), Timestamp('2018-04-26 04:55:58'), 5], [18, Timestamp('2018-04-26 04:59:58'), Timestamp('2018-04-26 05:23:32'), 36], [16, Timestamp('2018-04-26 05:29:03'), Timestamp('2018-04-26 05:35:25'), 8], [16, Timestamp('2018-04-26 05:40:53'), Timestamp('2018-04-26 06:03:18'), 24], [16, Timestamp('2018-04-26 06:06:22'), Timestamp('2018-04-26 06:47:41'), 48], [18, Timestamp('2018-04-26 06:49:38'), Timestamp('2018-04-26 07:11:18'), 32], [18, Timestamp('2018-04-26 07:23:02'), Timestamp('2018-04-26 07:23:02'), 1], [18, Timestamp('2018-04-26 07:58:52'), Timestamp('2018-04-26 08:30:38'), 47], [19, Timestamp('2018-04-26 09:07:32'), Timestamp('2018-04-26 09:14:54'), 13], [19, Timestamp('2018-04-26 09:22:17'), Timestamp('2018-04-26 09:43:59'), 41], [19, Timestamp('2018-04-26 09:47:07'), Timestamp('2018-04-26 10:14:40'), 51], [21, Timestamp('2018-04-26 10:37:26'), Timestamp('2018-04-26 10:37:26'), 1], [21, Timestamp('2018-04-26 10:42:50'), Timestamp('2018-04-26 10:46:13'), 3], [21, Timestamp('2018-04-26 10:49:33'), Timestamp('2018-04-26 10:50:23'), 2], [21, Timestamp('2018-04-26 10:55:43'), Timestamp('2018-04-26 11:01:18'), 3], [21, Timestamp('2018-04-26 11:08:18'), Timestamp('2018-04-26 11:14:37'), 10], [21, Timestamp('2018-04-26 11:17:43'), Timestamp('2018-04-26 11:18:23'), 2], [21, Timestamp('2018-04-26 11:25:18'), Timestamp('2018-04-26 11:40:39'), 21], [21, Timestamp('2018-04-26 11:46:32'), Timestamp('2018-04-26 11:52:01'), 8], [21, Timestamp('2018-04-26 12:08:36'), Timestamp('2018-04-26 12:48:06'), 51], [21, Timestamp('2018-04-26 12:55:12'), Timestamp('2018-04-26 12:55:12'), 1], [15, Timestamp('2018-04-26 13:07:08'), Timestamp('2018-04-26 13:36:37'), 44], [15, Timestamp('2018-04-26 13:43:26'), Timestamp('2018-04-26 14:06:16'), 29], [15, Timestamp('2018-04-26 14:10:42'), Timestamp('2018-04-26 14:12:05'), 3], [15, Timestamp('2018-04-26 14:17:52'), Timestamp('2018-04-26 14:19:37'), 4], [17, Timestamp('2018-04-26 14:26:16'), Timestamp('2018-04-26 14:26:16'), 1], [17, Timestamp('2018-04-26 14:34:33'), Timestamp('2018-04-26 14:40:38'), 6], [17, Timestamp('2018-04-26 14:44:03'), Timestamp('2018-04-26 14:55:47'), 19], [17, Timestamp('2018-04-26 15:02:16'), Timestamp('2018-04-26 15:11:54'), 16], [17, Timestamp('2018-04-26 15:19:03'), Timestamp('2018-04-26 15:21:06'), 7], [17, Timestamp('2018-04-26 15:26:09'), Timestamp('2018-04-26 15:33:04'), 11], [17, Timestamp('2018-04-26 15:37:37'), Timestamp('2018-04-26 15:50:04'), 20], [21, Timestamp('2018-04-26 15:56:50'), Timestamp('2018-04-26 15:57:39'), 3], [9, Timestamp('2018-04-26 16:16:55'), Timestamp('2018-04-26 16:24:16'), 14], [9, Timestamp('2018-04-26 16:34:59'), Timestamp('2018-04-26 17:57:00'), 111], [11, Timestamp('2018-04-26 18:06:36'), Timestamp('2018-04-26 18:55:34'), 67], [11, Timestamp('2018-04-26 19:02:42'), Timestamp('2018-04-26 19:12:21'), 14], [11, Timestamp('2018-04-26 19:17:52'), Timestamp('2018-04-26 19:41:04'), 33], [11, Timestamp('2018-04-26 19:51:15'), Timestamp('2018-04-26 20:27:38'), 56], [4, Timestamp('2018-04-26 20:40:37'), Timestamp('2018-04-26 20:53:51'), 15], [4, Timestamp('2018-04-26 20:58:38'), Timestamp('2018-04-26 21:04:10'), 8], [4, Timestamp('2018-04-26 21:07:45'), Timestamp('2018-04-26 21:20:28'), 14], [4, Timestamp('2018-04-26 21:28:55'), Timestamp('2018-04-26 22:18:39'), 70], [4, Timestamp('2018-04-26 22:27:30'), Timestamp('2018-04-26 22:52:59'), 42], [4, Timestamp('2018-04-26 22:56:14'), Timestamp('2018-04-26 23:04:51'), 13], [4, Timestamp('2018-04-26 23:08:40'), Timestamp('2018-04-26 23:46:02'), 52], [4, Timestamp('2018-04-26 23:52:01'), Timestamp('2018-04-26 23:57:46'), 9], [5, Timestamp('2018-04-27 00:16:52'), Timestamp('2018-04-27 02:05:25'), 125], [4, Timestamp('2018-04-27 02:11:48'), Timestamp('2018-04-27 02:31:26'), 27], [4, Timestamp('2018-04-27 02:52:40'), Timestamp('2018-04-27 03:11:35'), 30], [4, Timestamp('2018-04-27 03:19:56'), Timestamp('2018-04-27 03:20:29'), 2], [4, Timestamp('2018-04-27 03:28:30'), Timestamp('2018-04-27 03:31:44'), 6], [5, Timestamp('2018-04-27 03:35:22'), Timestamp('2018-04-27 03:37:14'), 4], [5, Timestamp('2018-04-27 03:41:32'), Timestamp('2018-04-27 03:42:37'), 5], [5, Timestamp('2018-04-27 03:49:27'), Timestamp('2018-04-27 03:51:17'), 3], [5, Timestamp('2018-04-27 03:55:47'), Timestamp('2018-04-27 04:06:08'), 18], [5, Timestamp('2018-04-27 04:10:01'), Timestamp('2018-04-27 04:16:59'), 15], [5, Timestamp('2018-04-27 04:20:06'), Timestamp('2018-04-27 04:53:51'), 46], [5, Timestamp('2018-04-27 04:57:27'), Timestamp('2018-04-27 05:03:46'), 11], [5, Timestamp('2018-04-27 05:06:51'), Timestamp('2018-04-27 05:08:14'), 3], [5, Timestamp('2018-04-27 05:14:46'), Timestamp('2018-04-27 05:24:20'), 19], [5, Timestamp('2018-04-27 05:32:39'), Timestamp('2018-04-27 05:32:39'), 1], [5, Timestamp('2018-04-27 05:39:37'), Timestamp('2018-04-27 05:46:09'), 9], [5, Timestamp('2018-04-27 05:49:24'), Timestamp('2018-04-27 05:49:24'), 1], [5, Timestamp('2018-04-27 05:53:19'), Timestamp('2018-04-27 05:57:59'), 9], [5, Timestamp('2018-04-27 06:01:17'), Timestamp('2018-04-27 06:05:36'), 12], [5, Timestamp('2018-04-27 06:09:32'), Timestamp('2018-04-27 06:12:02'), 5], [5, Timestamp('2018-04-27 06:16:56'), Timestamp('2018-04-27 06:17:32'), 2], [2, Timestamp('2018-04-27 06:24:56'), Timestamp('2018-04-27 06:45:01'), 25], [8, Timestamp('2018-04-27 07:09:34'), Timestamp('2018-04-27 07:16:42'), 12], [8, Timestamp('2018-04-27 07:19:43'), Timestamp('2018-04-27 07:39:08'), 27], [8, Timestamp('2018-04-27 07:42:58'), Timestamp('2018-04-27 07:44:08'), 2], [8, Timestamp('2018-04-27 07:47:24'), Timestamp('2018-04-27 07:51:09'), 5], [8, Timestamp('2018-04-27 07:56:14'), Timestamp('2018-04-27 09:34:03'), 114], [1, Timestamp('2018-04-27 09:35:53'), Timestamp('2018-04-27 09:35:53'), 1], [1, Timestamp('2018-04-27 09:41:22'), Timestamp('2018-04-27 09:45:38'), 7], [1, Timestamp('2018-04-27 09:49:46'), Timestamp('2018-04-27 09:52:39'), 5], [1, Timestamp('2018-04-27 09:58:05'), Timestamp('2018-04-27 10:37:05'), 56], [1, Timestamp('2018-04-27 10:40:52'), Timestamp('2018-04-27 11:39:23'), 82], [1, Timestamp('2018-04-27 11:45:50'), Timestamp('2018-04-27 11:51:35'), 9], [30, Timestamp('2018-04-27 12:35:00'), Timestamp('2018-04-27 13:03:00'), 43], [30, Timestamp('2018-04-27 13:06:41'), Timestamp('2018-04-27 13:14:01'), 17], [30, Timestamp('2018-04-27 13:38:29'), Timestamp('2018-04-27 13:42:47'), 3], [31, Timestamp('2018-04-27 16:05:01'), Timestamp('2018-04-27 16:23:05'), 37], [31, Timestamp('2018-04-27 16:29:26'), Timestamp('2018-04-27 16:34:39'), 12], [31, Timestamp('2018-04-27 16:44:13'), Timestamp('2018-04-27 16:53:28'), 14], [30, Timestamp('2018-04-27 17:03:37'), Timestamp('2018-04-27 17:09:33'), 12], [30, Timestamp('2018-04-27 17:12:56'), Timestamp('2018-04-27 18:01:50'), 89], [31, Timestamp('2018-04-27 18:07:48'), Timestamp('2018-04-27 18:08:58'), 2], [31, Timestamp('2018-04-27 18:14:02'), Timestamp('2018-04-27 18:38:04'), 41], [31, Timestamp('2018-04-27 18:43:02'), Timestamp('2018-04-27 18:50:41'), 14], [31, Timestamp('2018-04-27 18:54:30'), Timestamp('2018-04-27 19:07:05'), 26], [31, Timestamp('2018-04-27 19:11:14'), Timestamp('2018-04-27 19:18:07'), 18], [32, Timestamp('2018-04-27 19:25:30'), Timestamp('2018-04-27 19:45:04'), 30], [32, Timestamp('2018-04-27 19:59:57'), Timestamp('2018-04-27 20:04:29'), 6], [32, Timestamp('2018-04-27 21:01:00'), Timestamp('2018-04-27 21:21:12'), 29], [32, Timestamp('2018-04-27 21:26:01'), Timestamp('2018-04-27 21:26:01'), 1], [32, Timestamp('2018-04-27 21:29:14'), Timestamp('2018-04-27 21:38:02'), 16], [33, Timestamp('2018-04-27 21:47:07'), Timestamp('2018-04-27 21:47:07'), 1], [33, Timestamp('2018-04-27 21:51:57'), Timestamp('2018-04-27 21:53:09'), 3], [33, Timestamp('2018-04-27 21:57:56'), Timestamp('2018-04-27 22:05:44'), 13], [33, Timestamp('2018-04-27 22:12:18'), Timestamp('2018-04-27 22:26:18'), 26], [33, Timestamp('2018-04-27 22:30:25'), Timestamp('2018-04-27 22:56:28'), 39], [4, Timestamp('2018-04-27 23:07:35'), Timestamp('2018-04-27 23:58:32'), 66], [4, Timestamp('2018-04-28 00:04:51'), Timestamp('2018-04-28 01:06:48'), 83], [4, Timestamp('2018-04-28 01:10:07'), Timestamp('2018-04-28 01:26:25'), 26], [4, Timestamp('2018-04-28 01:30:15'), Timestamp('2018-04-28 01:46:57'), 25], [5, Timestamp('2018-04-28 01:55:32'), Timestamp('2018-04-28 02:03:07'), 12], [5, Timestamp('2018-04-28 02:06:09'), Timestamp('2018-04-28 02:38:31'), 41], [5, Timestamp('2018-04-28 02:41:50'), Timestamp('2018-04-28 03:05:37'), 32], [5, Timestamp('2018-04-28 03:09:36'), Timestamp('2018-04-28 03:18:33'), 13], [5, Timestamp('2018-04-28 03:22:36'), Timestamp('2018-04-28 03:36:06'), 20], [5, Timestamp('2018-04-28 03:41:08'), Timestamp('2018-04-28 03:42:07'), 5], [5, Timestamp('2018-04-28 03:45:45'), Timestamp('2018-04-28 03:53:36'), 18], [5, Timestamp('2018-04-28 03:56:51'), Timestamp('2018-04-28 04:16:38'), 25], [5, Timestamp('2018-04-28 04:20:37'), Timestamp('2018-04-28 04:26:49'), 8], [5, Timestamp('2018-04-28 04:30:57'), Timestamp('2018-04-28 04:48:54'), 26], [2, Timestamp('2018-04-28 05:10:09'), Timestamp('2018-04-28 05:17:56'), 11], [2, Timestamp('2018-04-28 05:20:59'), Timestamp('2018-04-28 05:23:32'), 6], [2, Timestamp('2018-04-28 05:45:12'), Timestamp('2018-04-28 06:00:59'), 26], [8, Timestamp('2018-04-28 06:22:14'), Timestamp('2018-04-28 06:26:15'), 5], [8, Timestamp('2018-04-28 06:29:47'), Timestamp('2018-04-28 06:38:07'), 11], [8, Timestamp('2018-04-28 06:49:24'), Timestamp('2018-04-28 08:10:21'), 98], [8, Timestamp('2018-04-28 08:14:18'), Timestamp('2018-04-28 08:42:06'), 33], [8, Timestamp('2018-04-28 08:46:37'), Timestamp('2018-04-28 08:48:21'), 3], [8, Timestamp('2018-04-28 08:51:45'), Timestamp('2018-04-28 08:58:57'), 10], [1, Timestamp('2018-04-28 09:05:01'), Timestamp('2018-04-28 09:05:52'), 2], [1, Timestamp('2018-04-28 09:11:26'), Timestamp('2018-04-28 09:11:52'), 2], [1, Timestamp('2018-04-28 09:15:45'), Timestamp('2018-04-28 09:28:09'), 19], [1, Timestamp('2018-04-28 09:32:45'), Timestamp('2018-04-28 09:37:37'), 9], [1, Timestamp('2018-04-28 09:40:50'), Timestamp('2018-04-28 09:47:05'), 9], [1, Timestamp('2018-04-28 09:51:56'), Timestamp('2018-04-28 10:04:43'), 19], [1, Timestamp('2018-04-28 10:09:56'), Timestamp('2018-04-28 10:17:18'), 15], [1, Timestamp('2018-04-28 10:20:41'), Timestamp('2018-04-28 10:32:19'), 22], [1, Timestamp('2018-04-28 10:35:54'), Timestamp('2018-04-28 10:55:48'), 30], [1, Timestamp('2018-04-28 11:02:46'), Timestamp('2018-04-28 11:04:31'), 4], [1, Timestamp('2018-04-28 11:07:38'), Timestamp('2018-04-28 11:14:34'), 14], [1, Timestamp('2018-04-28 11:21:56'), Timestamp('2018-04-28 11:22:15'), 2], [1, Timestamp('2018-04-28 11:27:56'), Timestamp('2018-04-28 11:28:37'), 3], [1, Timestamp('2018-04-28 11:34:32'), Timestamp('2018-04-28 11:34:32'), 1], [1, Timestamp('2018-04-28 11:42:42'), Timestamp('2018-04-28 11:42:42'), 1], [1, Timestamp('2018-04-28 11:49:52'), Timestamp('2018-04-28 11:52:16'), 8], [2, Timestamp('2018-04-28 12:24:54'), Timestamp('2018-04-28 12:48:13'), 31], [2, Timestamp('2018-04-28 12:51:51'), Timestamp('2018-04-28 12:52:24'), 2], [2, Timestamp('2018-04-28 12:56:02'), Timestamp('2018-04-28 13:39:37'), 57], [2, Timestamp('2018-04-28 13:44:04'), Timestamp('2018-04-28 13:54:24'), 16], [3, Timestamp('2018-04-28 14:01:44'), Timestamp('2018-04-28 14:10:43'), 14], [3, Timestamp('2018-04-28 14:13:45'), Timestamp('2018-04-28 14:41:06'), 39], [3, Timestamp('2018-04-28 14:45:53'), Timestamp('2018-04-28 14:59:51'), 22], [3, Timestamp('2018-04-28 15:03:01'), Timestamp('2018-04-28 15:13:04'), 11], [3, Timestamp('2018-04-28 15:17:45'), Timestamp('2018-04-28 15:25:19'), 11], [3, Timestamp('2018-04-28 15:28:33'), Timestamp('2018-04-28 16:03:06'), 49], [3, Timestamp('2018-04-28 16:09:00'), Timestamp('2018-04-28 16:30:04'), 29], [9, Timestamp('2018-04-28 16:36:25'), Timestamp('2018-04-28 17:04:45'), 40], [9, Timestamp('2018-04-28 17:07:57'), Timestamp('2018-04-28 17:36:43'), 35], [9, Timestamp('2018-04-28 17:41:40'), Timestamp('2018-04-28 18:12:54'), 45], [13, Timestamp('2018-04-28 18:20:45'), Timestamp('2018-04-28 18:20:45'), 1], [13, Timestamp('2018-04-28 18:26:00'), Timestamp('2018-04-28 19:14:39'), 62], [13, Timestamp('2018-04-28 19:20:40'), Timestamp('2018-04-28 19:29:38'), 15], [13, Timestamp('2018-04-28 19:34:41'), Timestamp('2018-04-28 19:36:05'), 2], [11, Timestamp('2018-04-28 19:50:57'), Timestamp('2018-04-28 19:51:20'), 2], [11, Timestamp('2018-04-28 19:55:53'), Timestamp('2018-04-28 20:20:31'), 37], [11, Timestamp('2018-04-28 20:24:58'), Timestamp('2018-04-28 20:43:15'), 30], [11, Timestamp('2018-04-28 20:48:06'), Timestamp('2018-04-28 21:23:51'), 47], [11, Timestamp('2018-04-28 21:28:44'), Timestamp('2018-04-28 21:30:34'), 4], [14, Timestamp('2018-04-28 21:34:59'), Timestamp('2018-04-28 21:44:14'), 15], [14, Timestamp('2018-04-28 21:50:00'), Timestamp('2018-04-28 22:04:52'), 23], [14, Timestamp('2018-04-28 22:15:33'), Timestamp('2018-04-28 22:30:02'), 28], [14, Timestamp('2018-04-28 22:33:31'), Timestamp('2018-04-28 22:43:44'), 14], [10, Timestamp('2018-04-28 23:12:56'), Timestamp('2018-04-29 00:28:30'), 84], [10, Timestamp('2018-04-29 00:35:24'), Timestamp('2018-04-29 00:40:46'), 9], [10, Timestamp('2018-04-29 00:50:06'), Timestamp('2018-04-29 00:55:52'), 7], [10, Timestamp('2018-04-29 01:00:55'), Timestamp('2018-04-29 01:37:56'), 45], [12, Timestamp('2018-04-29 01:48:05'), Timestamp('2018-04-29 01:49:17'), 2], [12, Timestamp('2018-04-29 01:54:50'), Timestamp('2018-04-29 01:54:50'), 1], [12, Timestamp('2018-04-29 02:04:37'), Timestamp('2018-04-29 02:08:18'), 7], [12, Timestamp('2018-04-29 02:13:25'), Timestamp('2018-04-29 02:36:10'), 16], [12, Timestamp('2018-04-29 02:42:13'), Timestamp('2018-04-29 02:47:10'), 4], [12, Timestamp('2018-04-29 02:53:20'), Timestamp('2018-04-29 02:57:35'), 4], [12, Timestamp('2018-04-29 03:01:11'), Timestamp('2018-04-29 03:03:00'), 2], [12, Timestamp('2018-04-29 03:10:08'), Timestamp('2018-04-29 03:20:55'), 9], [12, Timestamp('2018-04-29 03:24:05'), Timestamp('2018-04-29 03:39:54'), 15], [12, Timestamp('2018-04-29 03:46:03'), Timestamp('2018-04-29 04:08:15'), 19], [12, Timestamp('2018-04-29 04:11:55'), Timestamp('2018-04-29 04:31:04'), 17], [12, Timestamp('2018-04-29 04:34:07'), Timestamp('2018-04-29 04:36:47'), 3], [12, Timestamp('2018-04-29 04:41:07'), Timestamp('2018-04-29 04:57:55'), 14], [12, Timestamp('2018-04-29 05:05:17'), Timestamp('2018-04-29 05:09:09'), 3], [12, Timestamp('2018-04-29 05:15:30'), Timestamp('2018-04-29 05:17:31'), 3], [12, Timestamp('2018-04-29 05:23:10'), Timestamp('2018-04-29 05:56:32'), 26], [22, Timestamp('2018-04-29 06:24:38'), Timestamp('2018-04-29 06:30:31'), 8], [22, Timestamp('2018-04-29 06:34:40'), Timestamp('2018-04-29 06:38:06'), 5], [22, Timestamp('2018-04-29 06:42:55'), Timestamp('2018-04-29 06:46:53'), 6], [22, Timestamp('2018-04-29 06:56:24'), Timestamp('2018-04-29 07:05:16'), 17], [22, Timestamp('2018-04-29 07:09:32'), Timestamp('2018-04-29 07:11:46'), 4], [22, Timestamp('2018-04-29 07:20:48'), Timestamp('2018-04-29 07:34:15'), 22], [22, Timestamp('2018-04-29 07:37:40'), Timestamp('2018-04-29 07:37:40'), 1], [22, Timestamp('2018-04-29 07:40:45'), Timestamp('2018-04-29 07:41:30'), 2], [22, Timestamp('2018-04-29 07:45:20'), Timestamp('2018-04-29 07:56:19'), 15], [23, Timestamp('2018-04-29 08:06:40'), Timestamp('2018-04-29 08:06:40'), 1], [23, Timestamp('2018-04-29 08:13:09'), Timestamp('2018-04-29 08:15:32'), 3], [23, Timestamp('2018-04-29 08:25:41'), Timestamp('2018-04-29 08:32:05'), 13], [23, Timestamp('2018-04-29 08:48:47'), Timestamp('2018-04-29 08:49:12'), 2], [23, Timestamp('2018-04-29 08:53:30'), Timestamp('2018-04-29 09:07:38'), 26], [23, Timestamp('2018-04-29 09:11:16'), Timestamp('2018-04-29 09:11:16'), 1], [23, Timestamp('2018-04-29 09:19:49'), Timestamp('2018-04-29 09:20:36'), 3], [23, Timestamp('2018-04-29 09:23:50'), Timestamp('2018-04-29 09:27:46'), 5], [23, Timestamp('2018-04-29 09:32:45'), Timestamp('2018-04-29 09:43:41'), 17], [23, Timestamp('2018-04-29 09:48:26'), Timestamp('2018-04-29 09:51:56'), 6], [16, Timestamp('2018-04-29 09:56:49'), Timestamp('2018-04-29 10:11:44'), 17], [16, Timestamp('2018-04-29 10:15:36'), Timestamp('2018-04-29 11:01:01'), 54], [16, Timestamp('2018-04-29 11:05:08'), Timestamp('2018-04-29 11:08:03'), 4], [16, Timestamp('2018-04-29 11:11:25'), Timestamp('2018-04-29 11:26:24'), 19], [16, Timestamp('2018-04-29 11:30:04'), Timestamp('2018-04-29 11:36:08'), 8], [16, Timestamp('2018-04-29 11:41:07'), Timestamp('2018-04-29 11:50:43'), 15], [16, Timestamp('2018-04-29 11:55:41'), Timestamp('2018-04-29 11:57:25'), 3], [18, Timestamp('2018-04-29 12:00:34'), Timestamp('2018-04-29 12:04:00'), 6], [18, Timestamp('2018-04-29 12:11:36'), Timestamp('2018-04-29 12:13:51'), 7], [18, Timestamp('2018-04-29 12:19:46'), Timestamp('2018-04-29 12:20:42'), 4], [18, Timestamp('2018-04-29 12:24:37'), Timestamp('2018-04-29 12:36:22'), 22], [18, Timestamp('2018-04-29 12:45:06'), Timestamp('2018-04-29 12:50:45'), 15], [18, Timestamp('2018-04-29 12:55:22'), Timestamp('2018-04-29 13:09:31'), 24], [18, Timestamp('2018-04-29 13:12:56'), Timestamp('2018-04-29 13:15:19'), 4], [18, Timestamp('2018-04-29 13:18:57'), Timestamp('2018-04-29 13:31:14'), 18], [18, Timestamp('2018-04-29 13:37:23'), Timestamp('2018-04-29 13:45:00'), 10], [18, Timestamp('2018-04-29 13:49:37'), Timestamp('2018-04-29 13:56:52'), 10], [4, Timestamp('2018-04-29 14:16:17'), Timestamp('2018-04-29 14:23:12'), 14], [4, Timestamp('2018-04-29 14:26:13'), Timestamp('2018-04-29 15:28:49'), 85], [4, Timestamp('2018-04-29 15:32:44'), Timestamp('2018-04-29 16:07:25'), 47], [4, Timestamp('2018-04-29 16:12:50'), Timestamp('2018-04-29 16:39:19'), 36], [5, Timestamp('2018-04-29 17:07:10'), Timestamp('2018-04-29 17:26:03'), 29], [5, Timestamp('2018-04-29 17:30:08'), Timestamp('2018-04-29 18:45:52'), 92], [5, Timestamp('2018-04-29 18:48:55'), Timestamp('2018-04-29 19:08:38'), 27], [5, Timestamp('2018-04-29 19:12:58'), Timestamp('2018-04-29 19:36:52'), 33], [10, Timestamp('2018-04-29 19:53:18'), Timestamp('2018-04-29 20:08:11'), 18], [10, Timestamp('2018-04-29 20:13:45'), Timestamp('2018-04-29 21:29:27'), 82], [12, Timestamp('2018-04-29 21:38:58'), Timestamp('2018-04-29 21:46:37'), 7], [12, Timestamp('2018-04-29 21:50:51'), Timestamp('2018-04-29 21:52:56'), 2], [12, Timestamp('2018-04-29 21:56:17'), Timestamp('2018-04-29 22:15:39'), 17], [12, Timestamp('2018-04-29 22:18:57'), Timestamp('2018-04-29 23:46:55'), 64], [12, Timestamp('2018-04-29 23:55:31'), Timestamp('2018-04-30 00:01:49'), 10], [4, Timestamp('2018-04-30 00:10:17'), Timestamp('2018-04-30 00:40:32'), 50], [4, Timestamp('2018-04-30 00:48:00'), Timestamp('2018-04-30 00:55:29'), 11], [4, Timestamp('2018-04-30 01:00:13'), Timestamp('2018-04-30 01:09:45'), 16], [4, Timestamp('2018-04-30 01:13:51'), Timestamp('2018-04-30 01:48:20'), 48], [5, Timestamp('2018-04-30 01:51:48'), Timestamp('2018-04-30 02:56:33'), 80], [5, Timestamp('2018-04-30 03:02:27'), Timestamp('2018-04-30 03:03:19'), 5], [5, Timestamp('2018-04-30 03:08:11'), Timestamp('2018-04-30 03:12:47'), 14], [5, Timestamp('2018-04-30 03:19:29'), Timestamp('2018-04-30 03:21:43'), 4], [5, Timestamp('2018-04-30 03:25:15'), Timestamp('2018-04-30 03:31:57'), 12], [5, Timestamp('2018-04-30 03:37:27'), Timestamp('2018-04-30 03:39:11'), 8], [5, Timestamp('2018-04-30 03:44:20'), Timestamp('2018-04-30 03:44:40'), 2], [20, Timestamp('2018-04-30 04:21:29'), Timestamp('2018-04-30 04:22:14'), 4], [20, Timestamp('2018-04-30 04:25:39'), Timestamp('2018-04-30 05:52:48'), 86], [20, Timestamp('2018-04-30 05:56:18'), Timestamp('2018-04-30 05:59:23'), 4], [20, Timestamp('2018-04-30 06:03:32'), Timestamp('2018-04-30 06:07:41'), 5], [20, Timestamp('2018-04-30 06:11:56'), Timestamp('2018-04-30 06:46:42'), 34], [20, Timestamp('2018-04-30 06:49:58'), Timestamp('2018-04-30 07:24:53'), 37], [20, Timestamp('2018-04-30 07:30:38'), Timestamp('2018-04-30 07:51:19'), 21], [20, Timestamp('2018-04-30 07:54:37'), Timestamp('2018-04-30 07:56:34'), 3], [20, Timestamp('2018-04-30 08:00:41'), Timestamp('2018-04-30 08:47:35'), 48], [20, Timestamp('2018-04-30 08:51:41'), Timestamp('2018-04-30 08:54:45'), 4], [20, Timestamp('2018-04-30 08:58:56'), Timestamp('2018-04-30 09:08:31'), 9], [20, Timestamp('2018-04-30 09:12:17'), Timestamp('2018-04-30 10:13:54'), 59], [20, Timestamp('2018-04-30 10:18:08'), Timestamp('2018-04-30 10:40:23'), 23], [8, Timestamp('2018-04-30 10:53:54'), Timestamp('2018-04-30 12:01:15'), 81], [8, Timestamp('2018-04-30 12:11:57'), Timestamp('2018-04-30 12:17:04'), 6], [8, Timestamp('2018-04-30 12:20:18'), Timestamp('2018-04-30 12:32:32'), 13], [8, Timestamp('2018-04-30 12:35:41'), Timestamp('2018-04-30 13:06:35'), 34], [8, Timestamp('2018-04-30 13:10:02'), Timestamp('2018-04-30 13:18:34'), 11], [8, Timestamp('2018-04-30 13:22:59'), Timestamp('2018-04-30 13:33:20'), 13], [1, Timestamp('2018-04-30 13:46:49'), Timestamp('2018-04-30 13:50:56'), 10], [1, Timestamp('2018-04-30 13:54:58'), Timestamp('2018-04-30 15:37:23'), 148], [30, Timestamp('2018-04-30 16:20:42'), Timestamp('2018-04-30 16:45:23'), 42], [30, Timestamp('2018-04-30 16:49:24'), Timestamp('2018-04-30 17:54:21'), 111], [30, Timestamp('2018-04-30 17:58:32'), Timestamp('2018-04-30 18:13:15'), 29], [30, Timestamp('2018-04-30 18:18:40'), Timestamp('2018-04-30 18:53:57'), 68], [31, Timestamp('2018-04-30 19:06:42'), Timestamp('2018-04-30 19:56:50'), 83], [31, Timestamp('2018-04-30 20:07:35'), Timestamp('2018-04-30 20:28:36'), 41], [31, Timestamp('2018-04-30 20:32:08'), Timestamp('2018-04-30 21:22:59'), 88], [31, Timestamp('2018-04-30 21:27:38'), Timestamp('2018-04-30 21:48:26'), 37], [10, Timestamp('2018-04-30 21:58:37'), Timestamp('2018-04-30 22:45:05'), 60], [10, Timestamp('2018-04-30 22:51:19'), Timestamp('2018-04-30 23:59:04'), 77], [12, Timestamp('2018-05-01 00:26:26'), Timestamp('2018-05-01 00:26:26'), 1], [12, Timestamp('2018-05-01 00:31:35'), Timestamp('2018-05-01 00:40:01'), 7], [12, Timestamp('2018-05-01 00:50:06'), Timestamp('2018-05-01 00:53:24'), 5], [12, Timestamp('2018-05-01 00:59:16'), Timestamp('2018-05-01 01:44:49'), 36], [12, Timestamp('2018-05-01 01:48:12'), Timestamp('2018-05-01 02:04:34'), 14], [12, Timestamp('2018-05-01 02:07:52'), Timestamp('2018-05-01 02:12:07'), 4], [12, Timestamp('2018-05-01 02:23:44'), Timestamp('2018-05-01 02:23:44'), 1], [12, Timestamp('2018-05-01 02:26:56'), Timestamp('2018-05-01 02:28:17'), 2], [12, Timestamp('2018-05-01 02:32:52'), Timestamp('2018-05-01 02:42:04'), 10], [12, Timestamp('2018-05-01 02:45:30'), Timestamp('2018-05-01 02:53:58'), 8], [12, Timestamp('2018-05-01 02:58:11'), Timestamp('2018-05-01 03:05:30'), 8], [12, Timestamp('2018-05-01 03:09:35'), Timestamp('2018-05-01 03:11:09'), 2], [12, Timestamp('2018-05-01 03:24:23'), Timestamp('2018-05-01 03:24:23'), 1], [12, Timestamp('2018-05-01 03:30:13'), Timestamp('2018-05-01 03:34:28'), 3], [12, Timestamp('2018-05-01 03:39:34'), Timestamp('2018-05-01 03:39:34'), 1], [12, Timestamp('2018-05-01 03:47:08'), Timestamp('2018-05-01 03:47:08'), 1], [12, Timestamp('2018-05-01 03:51:31'), Timestamp('2018-05-01 03:59:26'), 9], [12, Timestamp('2018-05-01 04:02:34'), Timestamp('2018-05-01 04:04:18'), 4], [12, Timestamp('2018-05-01 04:08:49'), Timestamp('2018-05-01 04:17:51'), 8], [12, Timestamp('2018-05-01 04:21:55'), Timestamp('2018-05-01 04:30:12'), 10], [20, Timestamp('2018-05-01 05:11:01'), Timestamp('2018-05-01 05:26:25'), 16], [20, Timestamp('2018-05-01 05:31:42'), Timestamp('2018-05-01 05:37:51'), 7], [20, Timestamp('2018-05-01 05:44:15'), Timestamp('2018-05-01 05:59:19'), 13]]
[['0402868816_G' Timestamp('2018-04-02 06:34:01') 116 '1038408484' 1 1]
['0402868820_G' Timestamp('2018-04-02 06:35:08') 116 '1038408484' 1 1]
['0402868812_G' Timestamp('2018-04-02 06:35:46') 116 '1038408484' 1 1]
...,
['7200400013518000_G' Timestamp('2018-05-01 05:57:17') 115 'F005V16903' 20
1664]
['7200400013519000_G' Timestamp('2018-05-01 05:58:16') 115 'F005V16903' 20
1664]
['7200400013520000_G' Timestamp('2018-05-01 05:59:19') 115 'F005V16903' 20
1664]]
Out[6]:
'\nfinal_array\n[product type number, starting time_stamp, ending time_stamp, number of entries in each batch/ Batch Quantity]\ndf\n[product_name, time_stamp, process_number, TTNR, product type number ,batch/group number]\n'
In [7]:
#total number of batches of each product number(type)
length_list = len(final_array)
print (length_list)
buckets = [0] * (unique_sets+1)
buckets1 = [0] * (unique_sets+1)
for i in range(length_list):
a = final_array[i][0]
buckets[a] += 1
buckets1[a] = a
print (buckets)
print (buckets1)
1664 [0, 147, 76, 65, 223, 209, 87, 57, 123, 45, 57, 33, 178, 22, 23, 9, 34, 13, 45, 15, 54, 29, 19, 20, 16, 14, 2, 2, 10, 6, 9, 12, 5, 5] [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33]
In [8]:
###code for matching power timestamp with the product type and batch number
##put the genreated data in the file
'''
filename2 = 'analyses_data_corrected.xlsx'
pro_data = pd.read_excel(filename2, sheetname='RealtimeData')
pro_data['TIME'] = pd.to_datetime(pro_data['TIME'])
pro_data = pro_data.values
a,b = pro_data.shape
z = np.zeros((a,2))
pro_data = np.hstack((pro_data,z))
a,b = pro_data.shape
i = 0
print ("start")
while (i < a):
t3 = pro_data[i][0]
flag = 0
j = 0
while (j < length_list):
t1 = pd.to_datetime(final_array[j][1])
t2 = pd.to_datetime(final_array[j][2])
time1 = pd.Timedelta(t2 - t3).seconds + pd.Timedelta(t2 - t3).days*24*60*60
time2 = pd.Timedelta(t3 - t1).seconds + pd.Timedelta(t3 - t1).days*24*60*60
time3 = pd.Timedelta(t2 - t1).seconds + pd.Timedelta(t2 - t1).days*24*60*60
if (time1 >= 0 and time2 >= 0 and time3 >= 0 and (time1+time2 == time3)):
pro_data[i][b-2] = final_array[j][0]
pro_data[i][b-1] = j
flag = 1
break
j += 1
if (flag == 0):
pro_data = np.delete(pro_data, i, 0)
i = i - 1
a,b = pro_data.shape
i += 1
df = pd.DataFrame(pro_data)
filepath = 'my_excel_file_corrected.xlsx'
df.to_excel(filepath, index=False)
'''
Out[8]:
'\nfilename2 = \'analyses_data_corrected.xlsx\'\npro_data = pd.read_excel(filename2, sheetname=\'RealtimeData\')\npro_data[\'TIME\'] = pd.to_datetime(pro_data[\'TIME\'])\n\npro_data = pro_data.values\na,b = pro_data.shape\nz = np.zeros((a,2))\npro_data = np.hstack((pro_data,z))\na,b = pro_data.shape\n\ni = 0\nprint ("start")\nwhile (i < a):\n t3 = pro_data[i][0]\n flag = 0\n j = 0\n while (j < length_list):\n t1 = pd.to_datetime(final_array[j][1])\n t2 = pd.to_datetime(final_array[j][2])\n time1 = pd.Timedelta(t2 - t3).seconds + pd.Timedelta(t2 - t3).days*24*60*60\n time2 = pd.Timedelta(t3 - t1).seconds + pd.Timedelta(t3 - t1).days*24*60*60\n time3 = pd.Timedelta(t2 - t1).seconds + pd.Timedelta(t2 - t1).days*24*60*60\n if (time1 >= 0 and time2 >= 0 and time3 >= 0 and (time1+time2 == time3)):\n pro_data[i][b-2] = final_array[j][0]\n pro_data[i][b-1] = j\n flag = 1\n break\n j += 1\n if (flag == 0):\n pro_data = np.delete(pro_data, i, 0)\n i = i - 1\n a,b = pro_data.shape\n i += 1\n \ndf = pd.DataFrame(pro_data)\nfilepath = \'my_excel_file_corrected.xlsx\'\ndf.to_excel(filepath, index=False)\n'
In [9]:
##E/Q value of each batch. (energy/quantity in each batch)
filename4 = 'my_excel_file1_corrected.xlsx'
jj = []
counts = 0
df22 = pd.read_excel(filename4, sheetname='Sheet1')
df22= df22[["TIME","ACTIVEPOWER","PRODUCT_TYPE", "BATCH_TYPE", "REALTIME_E"]]
for i in range(len(final_array)):
df1 = df22[df22.BATCH_TYPE == i]
df22 = df22[df22.BATCH_TYPE != i]
df1 = df1.values
a,b = df1.shape
if (a == 0):
continue
counts += 1
p = df1[a-1][4]
q = df1[0][4]
energy = p - q
quantitites_value = final_array[i][3]
e_by_q = (energy*1.00)/quantitites_value
jj.append([])
jj[counts-1].append(final_array[i][0])
jj[counts-1].append(e_by_q)
jjj = pd.DataFrame(jj)
#jjj.to_excel('e_by_q.xlsx', index=False)
In [10]:
filename3 = 'my_excel_file1_corrected.xlsx'
i = 1
print (list1)
mean_standard = []
quantities_n = []
while (i <= unique_sets):
df1 = pd.read_excel(filename3, sheetname='Sheet1')
df1 = df1[df1.PRODUCT_TYPE == i]
df1 = df1[["TIME","ACTIVEPOWER","PRODUCT_TYPE", "BATCH_TYPE"]]
x = df1.BATCH_TYPE.unique()
jj = []
for kk in range(len(x)):
jj.append([])
df2 = df1[df1.BATCH_TYPE == x[kk]]
df2 = df2.values
aa, bb = df2.shape
ref_time = 0
for ll in range(aa):
jj[kk].append(df2[ll][1])
jj = pd.DataFrame(jj)
median_var = jj.median()
standard_deviation_from_mean_value = jj.std()
max_value = jj.max()
min_value = jj.min()
mean_value = jj.mean()
mv_list = pd.Series.tolist(median_var)
std_mean_list = pd.Series.tolist(standard_deviation_from_mean_value)
s_m = np.asarray(std_mean_list)
ppp = s_m.size
countttt_batch_size = 0
for variables in range(ppp):
if np.isnan(s_m[variables]):
countttt_batch_size += 1
mean_std_dev = np.nanmean(s_m)
mean_standard.append(mean_std_dev)
quantities_n.append(ppp - countttt_batch_size)
print("standard deviation is " + str(mean_std_dev))
mval_list = pd.Series.tolist(max_value)
min_val_l = pd.Series.tolist(min_value)
mean_val_list = pd.Series.tolist(mean_value)
neg_err = [b_i - a_i for a_i, b_i in zip(std_mean_list, mean_val_list)]
pos_err = [b_i + a_i for a_i, b_i in zip(std_mean_list, mean_val_list)]
y_a = list(range(0, len(mv_list)))
y_label = "Real Time Power of Product " + str(i) + " kW"
plt.figure(1, figsize=(20,10))
plt.subplot(211)
plt.plot(y_a, mv_list, 'r', label='median/predicted')
plt.plot(y_a, neg_err, 'brown', label='negative error')
plt.plot(y_a, pos_err, 'coral', label='positive error')
plt.title("product type" + str(i))
plt.xlabel('time-stamp in minutes')
plt.ylabel(y_label)
plt.legend()
plt.tight_layout()
plt.subplot(212)
plt.plot(y_a, mean_val_list, 'bx', label='mean power')
plt.plot(y_a, mval_list, 'y', label='maximum power')
plt.plot(y_a, min_val_l, 'g', label='minimum power')
plt.title("product type" + str(i))
plt.xlabel('time-stamp in minutes')
plt.ylabel(y_label)
plt.legend()
plt.tight_layout()
plt.show()
i += 1
mean_standard_array1 = mean_standard
timestamp_quantity_considered = quantities_n
print (mean_standard)
print (quantities_n)
print (list1)
list1_new = []
mean_standard_new = []
quantities_n_new = []
product_number = []
for i in range(len(mean_standard)):
if str(mean_standard[i]) != 'nan':
mean_standard_new.append(mean_standard[i])
quantities_n_new.append(quantities_n[i])
list1_new.append(list1[i])
product_number.append(i+1)
mean_standard = mean_standard_new
quantities_n = quantities_n_new
list1 = list1_new
print (mean_standard)
print (quantities_n)
print (list1)
print (product_number)
['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038305588', '116_1038305588', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359'] standard deviation is 3.49936124956
standard deviation is 3.68703065716
standard deviation is 3.74880587682
standard deviation is 3.03753382962
standard deviation is 3.5994465014
standard deviation is 3.7842768957
standard deviation is 3.76760705638
standard deviation is 3.93105038429
standard deviation is 2.94690317458
standard deviation is 3.46660737528
standard deviation is 3.86932682109
standard deviation is 3.19571440861
standard deviation is 3.21471392671
standard deviation is 3.41499956132
standard deviation is 2.73417698283
standard deviation is 3.8423087534
standard deviation is 3.74496777538
standard deviation is 3.61773649728
standard deviation is 3.99828831384
standard deviation is 2.97462522947
standard deviation is 3.51180720468
standard deviation is 3.53286277084
standard deviation is 3.8769922273
standard deviation is 3.01843345583
standard deviation is 3.55200832146
C:\Program Files\Anaconda3\lib\site-packages\numpy\lib\nanfunctions.py:703: RuntimeWarning: Mean of empty slice
warnings.warn("Mean of empty slice", RuntimeWarning)
standard deviation is nan
C:\Program Files\Anaconda3\lib\site-packages\numpy\lib\nanfunctions.py:703: RuntimeWarning: Mean of empty slice
warnings.warn("Mean of empty slice", RuntimeWarning)
standard deviation is nan
standard deviation is 3.59222072684
standard deviation is 3.21508449045
standard deviation is 2.43887891229
standard deviation is 2.84117539626
standard deviation is 4.15791921042
standard deviation is 1.94461638021
[3.4993612495580368, 3.6870306571611344, 3.7488058768225527, 3.0375338296172174, 3.5994465013966237, 3.784276895700394, 3.7676070563774253, 3.9310503842926572, 2.9469031745838019, 3.4666073752802822, 3.8693268210946399, 3.1957144086139548, 3.2147139267096527, 3.4149995613224315, 2.7341769828343323, 3.8423087534031906, 3.744967775378214, 3.6177364972793216, 3.9982883138418761, 2.9746252294687774, 3.5118072046767335, 3.532862770841172, 3.8769922273043442, 3.0184334558342241, 3.5520083214647347, nan, nan, 3.5922207268351505, 3.2150844904493332, 2.438878912286393, 2.8411753962604567, 4.1579192104221345, 1.944616380212306] [66, 54, 61, 92, 88, 75, 89, 103, 66, 75, 57, 46, 48, 53, 26, 64, 13, 52, 38, 81, 42, 37, 28, 47, 57, 0, 0, 15, 24, 49, 51, 20, 14] ['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038305588', '116_1038305588', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359'] [3.4993612495580368, 3.6870306571611344, 3.7488058768225527, 3.0375338296172174, 3.5994465013966237, 3.784276895700394, 3.7676070563774253, 3.9310503842926572, 2.9469031745838019, 3.4666073752802822, 3.8693268210946399, 3.1957144086139548, 3.2147139267096527, 3.4149995613224315, 2.7341769828343323, 3.8423087534031906, 3.744967775378214, 3.6177364972793216, 3.9982883138418761, 2.9746252294687774, 3.5118072046767335, 3.532862770841172, 3.8769922273043442, 3.0184334558342241, 3.5520083214647347, 3.5922207268351505, 3.2150844904493332, 2.438878912286393, 2.8411753962604567, 4.1579192104221345, 1.944616380212306] [66, 54, 61, 92, 88, 75, 89, 103, 66, 75, 57, 46, 48, 53, 26, 64, 13, 52, 38, 81, 42, 37, 28, 47, 57, 15, 24, 49, 51, 20, 14] ['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359'] [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 28, 29, 30, 31, 32, 33]
In [11]:
width = 0.5
y_pos = np.arange(len(product_number))
fig, ax = plt.subplots(figsize=(25, 10))
rects = ax.bar(y_pos, mean_standard, width ,color='r', align='edge' ,alpha=0.5)
ax.set_xticks(y_pos + width/2.)
ax.set_xticklabels(product_number, fontsize=10)
ax.set_xlabel('TTNR')
ax.set_ylabel('standard deviation')
def autolabel(rects,ii):
for rect in rects:
height = rect.get_height()
values = quantities_n[ii]
value1 = product_number[ii] + 1
value2 = mean_standard[ii]
ii += 1
ax.text(rect.get_x() + rect.get_width()/2., 1.08*height,
'%s' %(str(values)),
ha='center', va='bottom', fontsize=10)
autolabel(rects, 0)
plt.tight_layout()
plt.show()
filename3 = 'e_by_q.xlsx'
for i in range(unique_sets):
df1 = pd.read_excel(filename3, sheetname='Sheet1')
y_label = "Energy difference divided by quantity kWh"
fig, ax = plt.subplots(figsize=(25, 10))
ax.scatter(df1['PRODUCT_TYPE'], df1['E_by_Q'], alpha=0.5)
ax.set_xlabel('product number')
ax.set_ylabel(y_label)
ax.set_xticks(np.arange(unique_sets + 1))
plt.legend()
plt.tight_layout()
plt.show()
break
y_label = "number of batches/batch count for each product type"
width = 0.5
y_pos = np.arange(len(buckets1))
fig, ax = plt.subplots(figsize=(25, 10))
rects = ax.bar(y_pos, buckets, width ,color='r', align='center' ,alpha=0.5)
ax.set_xlabel('product number')
ax.set_ylabel(y_label)
ax.set_xticks(np.arange(unique_sets + 1))
def autolabel(rects,ii):
for rect in rects:
height = rect.get_height()
value = buckets[ii]
ii += 1
ax.text(rect.get_x() + rect.get_width()/2., 1.08*height,
'%s' %(str(value)),
ha='center', va='bottom', fontsize=10)
autolabel(rects, 0)
plt.tight_layout()
plt.show()
In [12]:
b1 = buckets
b2 = buckets1
b1.pop(0)
b2.pop(0)
Out[12]:
0
In [21]:
product_type_data = list(zip(b2, b1, list_process_number, ttnr_list, mean_standard_array1, timestamp_quantity_considered))
df1 = pd.DataFrame(product_type_data)
df1.columns = ['Product_No.', 'total_batch_No.', 'Process_no.', 'TTNR_val', 'mean_std_var', 'tstamp_freq.(for taking standard deviation average)']
df1
Out[21]:
| Product_No. | total_batch_No. | Process_no. | TTNR_val | mean_std_var | tstamp_freq.(for taking standard deviation average) | |
|---|---|---|---|---|---|---|
| 0 | 1 | 147 | 116 | 1038408484 | 3.499361 | 66 |
| 1 | 2 | 76 | 115 | 1038307052 | 3.687031 | 54 |
| 2 | 3 | 65 | 116 | 1038307052 | 3.748806 | 61 |
| 3 | 4 | 223 | 115 | 1038305585 | 3.037534 | 92 |
| 4 | 5 | 209 | 116 | 1038305585 | 3.599447 | 88 |
| 5 | 6 | 87 | 115 | 1038408318 | 3.784277 | 75 |
| 6 | 7 | 57 | 116 | 1038408318 | 3.767607 | 89 |
| 7 | 8 | 123 | 115 | 1038408484 | 3.931050 | 103 |
| 8 | 9 | 45 | 115 | 1038305594 | 2.946903 | 66 |
| 9 | 10 | 57 | 115 | 1038407804 | 3.466607 | 75 |
| 10 | 11 | 33 | 116 | 1038305594 | 3.869327 | 57 |
| 11 | 12 | 178 | 116 | 1038407804 | 3.195714 | 46 |
| 12 | 13 | 22 | 115 | 1038407806 | 3.214714 | 48 |
| 13 | 14 | 23 | 116 | 1038407806 | 3.415000 | 53 |
| 14 | 15 | 9 | 115 | 1038408272 | 2.734177 | 26 |
| 15 | 16 | 34 | 115 | 1038408104 | 3.842309 | 64 |
| 16 | 17 | 13 | 116 | 1038408272 | 3.744968 | 13 |
| 17 | 18 | 45 | 116 | 1038408104 | 3.617736 | 52 |
| 18 | 19 | 15 | 115 | 1038407334 | 3.998288 | 38 |
| 19 | 20 | 54 | 115 | F005V16903 | 2.974625 | 81 |
| 20 | 21 | 29 | 116 | 1038407334 | 3.511807 | 42 |
| 21 | 22 | 19 | 115 | 1038408462 | 3.532863 | 37 |
| 22 | 23 | 20 | 116 | 1038408462 | 3.876992 | 28 |
| 23 | 24 | 16 | 115 | 1038407754 | 3.018433 | 47 |
| 24 | 25 | 14 | 116 | 1038407754 | 3.552008 | 57 |
| 25 | 26 | 2 | 115 | 1038305588 | NaN | 0 |
| 26 | 27 | 2 | 116 | 1038305588 | NaN | 0 |
| 27 | 28 | 10 | 115 | 1038407332 | 3.592221 | 15 |
| 28 | 29 | 6 | 116 | 1038407332 | 3.215084 | 24 |
| 29 | 30 | 9 | 115 | 1038408840 | 2.438879 | 49 |
| 30 | 31 | 12 | 116 | 1038408840 | 2.841175 | 51 |
| 31 | 32 | 5 | 115 | 1038305359 | 4.157919 | 20 |
| 32 | 33 | 5 | 116 | 1038305359 | 1.944616 | 14 |
In [ ]:
In [ ]: